ExcelAtEverything
Active Member
- Joined
- Jan 30, 2021
- Messages
- 351
- Office Version
- 2019
- Platform
- Windows
Hi there!
Looking for alternate solutions for a different problem, and wondering why in this Pivot Table (derived from connection-only queries to Data Model), I am not able to produce running total rows instead of running total columns. When I select the dropdown, the only available option is Org # which produces running totals top to bottom for each column. I would like the numbers to be running totals for each store, L to R. Instead, it only allows me to do a running total from top to bottom which does me no good.
Interestingly, when I load the months into the Pivot Table I have to drag them in month by month. Each month is a separate thing that I have to drag in, instead of just pulling in "date". I mention that because the unusualness of it makes me think it must be related somehow.
Is there a workaround or can someone help explain why this is happening?
Thanks.
Looking for alternate solutions for a different problem, and wondering why in this Pivot Table (derived from connection-only queries to Data Model), I am not able to produce running total rows instead of running total columns. When I select the dropdown, the only available option is Org # which produces running totals top to bottom for each column. I would like the numbers to be running totals for each store, L to R. Instead, it only allows me to do a running total from top to bottom which does me no good.
Interestingly, when I load the months into the Pivot Table I have to drag them in month by month. Each month is a separate thing that I have to drag in, instead of just pulling in "date". I mention that because the unusualness of it makes me think it must be related somehow.
Is there a workaround or can someone help explain why this is happening?
Thanks.
