substraction of rows in table view

2964744

Hi Expert,

I have requirement like below screen shot (in below i have showed one column measure, but we have 20 measure with MoM%, QoQ% YDT% etc). please let me know if you have any idea/solutions to resolve my below issue. thanks

1. without creating pivot table (must need to table view only)

2.  can't use union method in my report (because using union we are unable to pass presentation variable values into drill through page  Bug 22698253 : FORMULA WITH PRESENTATION VARIABLE IS NOT PASSING TO DETAIL REPORT)

3. Tried with new calculated item at Business unit column its not working as expected result (it's showing the country values @ total level. but we don't want to show country values at total level)

4. tried new calc. item at Business unit  ($1 -($2+$3+$4+$5)) column level but its still showing list of country at new calculated item row (Non Bu total)

Thomas Dodds

What about a case statement that flags BU/Non-BU?  then show the Total for each flag?

cesar.advincula.o

Hello, there is no problem.using union if.you pass the same.presentation.variable, if you.pass two presentation.variables to one.column.In the union.statement there is a.problem. recently I do.A.sample of.this..is calculated measure check the.sample in the.following link e

Kind regards,