• Replies 4 replies
  • Subscribers 961 subscribers
  • Views 57 views
  • Users 0 members are here
Related

Grand Total vs Average (labels and variations)

Nicola Cann
$organization

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!

Parents
  • $organization

    Hey Nicola,

    You are bucketing this right?

    • Average in the Right Column
    • Sum at the bottom

    I'm subtotal by SUM for the bottom row and the average column is the sum of three columns divided by three

    • Buckets are ( sum([Ticket  Count]) , [Production Season] )
    • Average is  sum([Ticket  Count])  / 3 (Average is a tiny bit off to be honest)


    Nicolaaverageandsum.dash

  • $organization in reply to Heath Wilder

    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 :/

Reply
  • $organization in reply to Heath Wilder

    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 :/

Children