Hi, I'm brand new to Tableau and haven't been able to find an answer after lots of googling and experimenting. I am trying to figure out how to calculate a row "Per Store Average" using Grand Totals as the numerator (is that even possible or do I need to manually create a table calculation for Totals and work off that?).
So far I have built the table below and am missing the highlighted piece:
Hi Althea,
Think you may be looking for total divided by average; in your table (above), create a calculated field with the formula: Total(Sum([Gross Revenue]))/Avg([Gross Revenue])
Apply the cf to the text mark then right-mouse click the pill to change the compute using to Product Category.
Total is a window calculation and in this situation is finding the total of the specified window (Gross revenue) then dividing it against the Product Category values
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.