Subtotal Problem off Cube data

[Arsenal]

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.

[Arsenal]

I guess another way of asking the question is, how can I create a calculation in report studio based off categories

[Arsenal]

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? ???

[MFGF]

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.

[dwalsh2]

I'm having the same issue, any suggestions?

DW