Change Grand Total row to display Difference in Pivot Widgets

Comments

4 comments

  • Avatar
    Oxana Noa Umansky

    Thanks Kobbi!

    0
    Comment actions Permalink
  • Avatar
    Bobbie Peterson

    How do I do this for the pivots "Columns grand totals" instead of for the "Row grand totals"? I've a pivot with totals that I'm using a date in "Days" format in the Columns (so I'm breaking by the day on the pivot). Initially I'm comparing the results of the two days, and I would like the grand total for the days Columns to be a difference total instead of a grand total as doing above.

    Thanks,

    Bobbie Peteson

    0
    Comment actions Permalink
  • Avatar
    Bobbie Peterson

    Also I need it for a 1-row pivot. So that can make the widget a Measure Changer Widget. 

    See this link: https://support.sisense.com/hc/en-us/community/posts/221225468-The-Measure-Changer-Widget-

     

    0
    Comment actions Permalink
  • Avatar
    Jessica Orlando

    Is there a way to overwrite the Subtotal row so that row just shows blank? The customer wants a blank row between the years for a cleaner look

    0
    Comment actions Permalink

Please sign in to leave a comment.