Hello!I'm hoping there is a simple solution to this - I've created a pivot table with ticket sales 6 weeks out from a performance date. What I would like to see is a grand total of those 6 weeks of sales at the bottom, and an average of the ticket sales for each row on the right (ie. average at 6 weeks out, 5 weeks out, etc)
I can do either/or, but I can't seem to get both. Also when I do "subtotal by AVERAGE", the label on the pivot table still says Grand Total - is there a way to change this lable?I've added a picture to show what I'm working with and what I'd like to see
Thanks in advance!
Hey Nicola,
You are bucketing this right?
I'm subtotal by SUM for the bottom row and the average column is the sum of three columns divided by three
Nicolaaverageandsum.dash
Mmm no I'm not bucketing this - I've got Rows as weeks prior to performance, but then I used Columns to get the production season (I like this because then I can just change the dashboard filters to view this data for any production season). The value is then the total ticket count, no filtering.I like the idea of bucketing this, but it feels less flexible within the dashboard :( Just annoying that I cant update the Grand Total label, I'd even be happy with average across the week, but even when I select subtotal by Average, I still get the label "Grand Total" in the table :/
Can I interest you in a sisense script update ...https://support.sisense.com/kb/en/article/changing-the-grand-total-label-on-pivot-table
Thank you!I'm surprised this isn't automatic depending on the subtotal selected, or at least easily editable! But I'll have a play with this for now! Thanks!