Comments
-
Hi! The Show Subtotal option is still there and checked in the setting. And it is the entire subtotal row missing unfortunately. I may have to try to recreate the same pivot table again to see if the subtotal row will show up again, but this is really bizarre. — Update: I switched Pivot Table to Mega Table and was able to…
-
Data wasn't changed either. The values I was using subtotals on were some simple dollar amount numbers and they are all showing as normal, so the subtotal should still work in this case.
-
Hi @GrantSmith, thanks for your response. I have been trying to apply your method to my data, but I still can't make it work on a line graph. I also partitioned by year, but the graph looks weird with the months duplicated. Is there a way to create two running totals for this year and last year, and put them in the same…
-
Thank you! This does look complicated but I will take a look. Would be nice if we can easily alter it in the settings section :)
-
Thanks for your response. My original question was to present y axis in different format (variable a: '$…', variable b: '…%', etc.), but it does seem like that is not something that I can manipulate currently.
-
@GrantSmith That was actually my original approach, but I do think combining all views together in one table saves more time for the users.