Hi All,
Let's start by saying that I have the dimensions - Payment Type and Product Type and 2 measures.
I have a crosstab where the rows will have Payment Type, column will have Product Type and the 2 measures.
Product Type
Payment Type Measures
The above is how the report looks. Below is the elaboration
Product A Product B
Tot Amt Refund Amt Total Amt Refund Amt
Cash 10 5 20 10
Check 50 0 30 0
Credit Card
Bank
Total (All except Bank)
Grand Total
And so on
Now to get the subtotal for Total of everything except bank, I created a data item, went to the first level of the cube (which is named Payment Type), expanded the Members section and pulled in Payment Type and Bank and did a subtraction
Now, this works fine for the subtotal row if there is no selection made in the prompt for Payment Type. If a selection of say Check is made then the subtotal row just shows a blank instead of 0's. Even if there is data for which the subtotal should be showing something, it turns up blank. In other words, the subtotal row functions correctly only if there is no selection made in the Payment Type prompt
How do I get it to show 0's?
Thanks for any and all help.
I guess another way of asking the question is, how can I create a calculation in report studio based off categories
Just found out that the issue occurs in other reports as well
Basically, if you have a subtotal calculation off categories from a dimension, and there is a prompt on that dimension from which users can pick and choose categories, then if that prompt is used to choose categories, the subtotal will not work.
If the prompt is left with no values then the subtotal works
Any suggestions? ???
Hi,
How have you implemented your prompt - is it via a detail filter, or did you code a calculated expression for your row heading as
set([payment type level] -> ?param?)
If you can provide a bit more detail on how your report is currently defined, I may be able to suggest a couple of alternatives that may work.
Best regards,
MF.
I'm having the same issue, any suggestions?
DW