February 19, 2021
I loaded my sheet into a Data Model because later I want to put Measures into the datamodel.
When I make a power pivot table from the Datamodel 1 don't get subtotals.
When the sheet is not in a Datamodel the pivot table gives subtotals.
In attachment you can find the file. The Tab Data is the data, the tab PVT is the Pivot made from the data tab before i put it in a Datamodel. The pivot Table in The Tab DM PVT No Sub you can find the Pivot Table made from the data after it is put in the Datamodel as you can see in this Pivot Table there are no Subtotals. I search and tried the several Pivot Table Options but i can(t find a solution.
Anyone who knows the reason ?
Thank You In Advance