I have created report to show all values in crosstab whether they a value or not. I then have created total both in rows and the columns. To that end I wondering if anyone see this behavior before. I have a created a set on the dimension side but the total is doing the whole report not on the set. It seems to bypassing it for some reason.
Here is the set data item
Set(Declined,No Change,Overridden On Suggested Out Tol,Overridden On UnSuggested,Suggested - No Action)
Here is the calculation
total(total(Post Avg Weekly Units for Not Followed)-total(Pre Avg Weekly Units for Not Followed) for Not Followed)/total(Pre Avg Weekly Units for Not Followed)
I will also include the outputs
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.