Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, How to get the Total by month if partial sums does not show it?, I need the totals on top of each month.
I attached the App.
Any sugestion would be great!!
Thank you all!!
Probably there is some more elegant solution, but for now, try
=if(Dimensionality()=0,
sum({$<Rubros1={'Imp. Flete M.N.'}, Mes={'*'}>}[Imp. Flete M.N.])
+sum({$<Rubros1={'Imp. Base M.N.'}, Mes={'*'}>}[Imp. Base M.N.])
+sum({$<Rubros1={'Imp.Surcharge M.N.'}, Mes={'*'}>}[Imp.Surcharge M.N.]),
if(Rubros1 = 'Imp. Flete M.N.', sum({$<Rubros1={'Imp. Flete M.N.'}, Mes={'*'}>}[Imp. Flete M.N.]) ,
if(Rubros1 = 'Imp. Base M.N.', sum({$<Rubros1={'Imp. Base M.N.'}, Mes={'*'}>}[Imp. Base M.N.]) ,
if(Rubros1 = 'Imp.Surcharge M.N.', sum({$<Rubros1={'Imp.Surcharge M.N.'}, Mes={'*'}>}[Imp.Surcharge M.N.]) ,))))
Probably there is some more elegant solution, but for now, try
=if(Dimensionality()=0,
sum({$<Rubros1={'Imp. Flete M.N.'}, Mes={'*'}>}[Imp. Flete M.N.])
+sum({$<Rubros1={'Imp. Base M.N.'}, Mes={'*'}>}[Imp. Base M.N.])
+sum({$<Rubros1={'Imp.Surcharge M.N.'}, Mes={'*'}>}[Imp.Surcharge M.N.]),
if(Rubros1 = 'Imp. Flete M.N.', sum({$<Rubros1={'Imp. Flete M.N.'}, Mes={'*'}>}[Imp. Flete M.N.]) ,
if(Rubros1 = 'Imp. Base M.N.', sum({$<Rubros1={'Imp. Base M.N.'}, Mes={'*'}>}[Imp. Base M.N.]) ,
if(Rubros1 = 'Imp.Surcharge M.N.', sum({$<Rubros1={'Imp.Surcharge M.N.'}, Mes={'*'}>}[Imp.Surcharge M.N.]) ,))))
Yes Stefan!! it worrks Excelent!!
Thank you very Much!!
You're welcome.
Just checked that the 'usual suspect' sum-of-rows-in-pivot-table using advanced aggregation also works:
=sum(aggr(
if(Rubros1 = 'Imp. Flete M.N.', sum({$<Rubros1={'Imp. Flete M.N.'}, Mes={'*'}>}[Imp. Flete M.N.]) ,
if(Rubros1 = 'Imp. Base M.N.', sum({$<Rubros1={'Imp. Base M.N.'}, Mes={'*'}>}[Imp. Base M.N.]) ,
if(Rubros1 = 'Imp.Surcharge M.N.', sum({$<Rubros1={'Imp.Surcharge M.N.'}, Mes={'*'}>}[Imp.Surcharge M.N.]) ,)))
,Rubros1,Mes))