Forum

Different results w...
 
Notifications
Clear all

Different results when moving fields around in PivotTable

3 Posts
2 Users
0 Reactions
65 Views
(@zchase)
Posts: 18
Eminent Member
Topic starter
 

The result of the pivot-table changes when i move the country field to the front and behind.

Is there a way to fix this? I wish to have the country field right at the front.

 

Countryinfront.pngCountrybehind.png

 
Posted : 30/09/2020 7:59 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Francis,

What do you mean 'it changes'? I can't tell what has changed from the images attached and the totals at the top are the same. 

Mynda

 
Posted : 30/09/2020 8:54 pm
(@zchase)
Posts: 18
Eminent Member
Topic starter
 

I solved the problem by unchecking the Filters option (Include filtered items in totals)

 

They are showing more information that is not necessary.

 

pivtotable_options.PNG 

 
Posted : 01/10/2020 1:51 am
Share: