Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I did a table where I´m using the following expression:
=sum(distinct(Kg*Multiplicador))
But the partial sum filed does not add the numbers correctly it should say 4.636 but is showing 4.488:
How can I post a box with a qvw example in this topic, I´ve seen that on several topics.
Thanks
In Pivot table, the total is usually the expression total and not the total of the row. This works fine till you use something like distinct which at each row level would be diffirent than at the total level.
You need to use the aggr function to achieve the total of the rows.
=Sum( aggr(sum(distinct(Kg*Multiplicador)),Embalaje,Calibre,Embalaje_Eq,Calibre_Eq))
Nimish
The option to 'attach' is at the top of the page where you write your posts, under the 'options' tab.
Thank you very much, here is the model with the chart.
Any help is more than welcome!
In Pivot table, the total is usually the expression total and not the total of the row. This works fine till you use something like distinct which at each row level would be diffirent than at the total level.
You need to use the aggr function to achieve the total of the rows.
=Sum( aggr(sum(distinct(Kg*Multiplicador)),Embalaje,Calibre,Embalaje_Eq,Calibre_Eq))
Nimish
Thank you very much Nimish it worked perfect