I don't get Subtotals in my Power Pivot Table

[MarcBergmans]

Hello,

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 inthis 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

[rorya]

Just right click one of the day cells and choose the 'Subtotal Day' option. In the field settings you can choose whether to display the subtotals above or below each group.

[rorya]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

It appears you've done this with both of your questions thus far, and haven't responded to anyone that has assisted in any forum. You might want to rethink that approach before people just stop helping.

[Link added] https://www.myonlinetraininghub.com/...in-a-datamodel

[AliGW]

@Rory - as the OP is new here, we should provide the link(s) for him this time (see the footnotes in the forum rules), so would you mind adding them to the admin notice, please? I can't see where the cross-posts are, otherwise I'd do it for you.

[rorya]

I've added the one I'm aware of.

[AliGW]

Thanks, Rory.