Totals within year in pivot table

[bartvanwetten]

Hi,

can anybody help me out on this one. The QlikView document is attached.

If I select one year the percentage of the total amount is show correctly. Now if I select two years it should show the percentage still 'within' the year and not, as now, the percentage of the total within the selected two years.

Thanks in advance!

[vishsaggi]

What is that you are expecting? Can you give your expected values you want to see in your table?

[sunny_talwar · Accepted solution]

Try this

=Sum( Aantal_per_eenheid)/  sum(total <Periode_Jaar_Only> Aantal_per_eenheid)

[bartvanwetten]

Sunny,

like charm again. Thx!

Bart