Summary Total calculating Incorrectly

[dmk.3678]

Hi Guys, I have an issue in Reports created out of DMR Model.
I have report with crosstab with multi select filter of Quarters having option Qtr1, Qtr2, Qtr3, Qtr4. By default i am keeping Qtr1 as default to run the report.
At Raw i have 'Age Category'
At Columns Raw1 i have Quarter and Below to that i have Cost, Revenue, Margin (Revenue-Cost), Margin %(Margin/Revenue) and Average Cost.

See attached Screenshot. The Total summary raw is calculated automatically (used Summarize tool -> Total option in Report Studio).
Now i have set the Average of LOS and Margin % column solve order to 2 as Total Column has solve order 1 by default.
Now when i run this by default for Qtr1 it gives the correct data in summary Total raw for Average and % column, but when i select the Qtr1 and Qtr2 both then it does not and by default it shows the Total SUM of the column elements.

Please suggest what can i do to resolve this. I have tried using Automatic Summary Option, but it started giving error PCA-ERR-0062 - The 'tuple' node is not expected to be a 'tuple'.

FYI: - My Filter Prompt for Quarter is on Report output page with Apply button. I dont have prompt page. if i use prompt page, this works fine. but i dont want to use prompt page.

Please help.

[MFGF]

Hi Guys, I have an issue in Reports created out of DMR Model.
I have report with crosstab with multi select filter of Quarters having option Qtr1, Qtr2, Qtr3, Qtr4. By default i am keeping Qtr1 as default to run the report.
At Raw i have 'Age Category'
At Columns Raw1 i have Quarter and Below to that i have Cost, Revenue, Margin (Revenue-Cost), Margin %(Margin/Revenue) and Average Cost.

See attached Screenshot. The Total summary raw is calculated automatically (used Summarize tool -> Total option in Report Studio).
Now i have set the Average of LOS and Margin % column solve order to 2 as Total Column has solve order 1 by default.
Now when i run this by default for Qtr1 it gives the correct data in summary Total raw for Average and % column, but when i select the Qtr1 and Qtr2 both then it does not and by default it shows the Total SUM of the column elements.

Please suggest what can i do to resolve this. I have tried using Automatic Summary Option, but it started giving error PCA-ERR-0062 - The 'tuple' node is not expected to be a 'tuple'.

FYI: - My Filter Prompt for Quarter is on Report output page with Apply button. I dont have prompt page. if i use prompt page, this works fine. but i dont want to use prompt page.

Please help.

Hi,

Some questions:

1. How are you applying the member(s) returned by your prompt? Are you using a dimensional expression for the quarters in your crosstab (and if so, what expression), or a detail filter?
2. When you select multiple quarters, what is the expected output? Do you want to see the individual quarters, followed by a summary of all quarters?
3. Can you share the expression for calculating your average - I'm guessing it's a query calculation if you had to set the solve order to 2?

Cheers!

MF.

[dmk.3678]

See Attached This is what i am trying to do. You can filters i am using, and the cross-tab output.

Answers of your questions.

1) No i am not using detail filter. its DMR so i am using slicer. like #promptmany ('quarter','memberuniquename','set([KFSH DRG COST].[Quarter].[Quarter].[Quarter]->[all].[1])','set(','',')')#

2) Yes, see the attached screen. See the Total Summary Raw for Margin %. Its adding up the values instead calculating %.
3) In screenshot, Cost, Revenue and No Encounters are measures used directly on report. Margin is a simple Data item having expression Revenue-Cost, and Margin % is again a simple Data Item having expression Margin/Revenue, i set the Data format to Percent, so it calculates and show %.

I am not calculating the Average on report, but at FM level. i have created measure and set the Aggregate Property to Average.