Pivot Total do not work properly

[MT4T]

Hey,

I have issue with total row in pivot table.

All of my value collumns are from measures.

Total work mainly with one row or simple filter. Which is somewhat useless.

Any help? I use only one dimension.

[JordyWegman]

Hi,

Could you add your QVF maybe?

Jordy

Climber

[MT4T]

Sorry in attachement.

[JordyWegman · Accepted solution]

Hi,

This is due to your calculation because of dividing by mid. When the totals are aggregated, you give multiple mid values for when there can only be one.

You can:

1. Choose to adjust your calculation
2. Create a table as my attachment and set the Totals to 'Sum'

Jordy

Climber