Pivot Grid - Total Value is wrong

[#1]

Hi! Look at the Expression "Conten." in the attached image. The "Total" value is wrong.

Expression "Conten." = count({<BGLOGContenedorOBodega={'CONT'}>}DISTINCT BGLOGContenedorNro)

Thanks

[vishsaggi]

IS it possible to share a sample app to look into please ?

[richard_chilvers]

Have you checked the Total Mode on the Expressions tab of the chart ?

[Gysbert_Wassenaar · Accepted solution]

The total value is correct, but you want a sum of counts instead of a count at the total level. So, sum the counts:

sum(aggr(count( ...stuff...) , Dim1, Dim2, ... etc)). Replace Dim1, Dim2, ... etc with the dimensions of your pivot table.

[#5]

Hi! Yes! In the second attachment you can see that is disabled (i don't know why)

Thanks

[#6]

Ok! The problem is that Dimensions are dynamics. The end user can select/unselect the dimension dynamically.

Thkanks

[Anil_Babu_Samineni]

Perhaps This?

[sunny_talwar]

How are they selecting it? Can you share a screenshot of the dimension tab?

[Gysbert_Wassenaar]

Then use a straight table instead of a pivot table and set the Total Mode of the expression to Sum of rows.

[#10]

Thanks but i need to use a pivot table.

Now is working. I did it using variables to get the selected dimensions and adding it to the expression that you shared me.

Thanks