Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have table :
Divison | Fin. Mounth | Revenues |
ABA | Jan | 740 123 € |
ABA | Feb | 1 013 241 € |
ABA | Mar | 232 803 € |
Jan | 740 123 € | |
Feb | 1 013 241 € | |
Mar | 232 803 € |
And I don´t know, why show me sum of rows. I need only first 3 rows.
Divison | Fin. Mounth | Revenues |
ABA | Jan | 740 123 € |
ABA | Feb | 1 013 241 € |
ABA | Mar | 232 803 € |
Could you help me ? Thank you.
Would you be able to share a screenshot of what you are seeing?
May be use this in pivot expression
Num(Sum({<Divison -= {'$(=If(Len(Division)>0))'}>}Revenues),'#,##0.00€')
It is OK: I have problem in my Set analyse.
yes, it is OK
If you solve your issue, You may close this thread by flag "Correct Answer"