Managment Reporter : Row data should not show for a particular coloumn

(0) Share

Report

Posted on by Mohamed Shuhaib

HI Everyone

We have a requiremnet where row data should not be shown or used in any calculation for a particular coloum ?

is it possible to achive in managment reporter

All responses (13)

Answers (1)

Mohamed Shuhaib 51 on at

Like (1)

Report

RE: Managment Reporter : Row data should not show for a particular coloumn

Hi Ludwig

modified dimension filter in the column definition to exclude the main accounts 3093-3110 from columns C and F . It Showed only rows 3093-3110.

modified dimension filter in the column definition to include the main accounts other than 3093-3110 from columns C and F . It Worked
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Managment Reporter : Row data should not show for a particular coloumn

OK.

Can you then modify your dimension filter in the column definition and exclude the main accounts 3093-3110 from columns C and F?

You already have a dimension filter in place there and need to extend it only.

Best regards,

Ludwig
Mohamed Shuhaib 51 on at

Like (0)

Report

RE: Managment Reporter : Row data should not show for a particular coloumn

Hi Ludwig

i changed the parameter to calculate first columns and then rows. issue not resolved .

changed the parameter back to calculate first rows and then columns . Issue not resloved
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Managment Reporter : Row data should not show for a particular coloumn

Hello Mohamed,

There is a report setting (parameter) available for that.

Should be in the settings tab of your report and called 'calculation priority'.

Please try running your report with different parameter settings to see if this fixes the issue.

Best regards,

Ludwig
Mohamed Shuhaib 51 on at

Like (0)

Report

RE: Managment Reporter : Row data should not show for a particular coloumn

Hi Ludwig

How can we change the parameter to calculate first columns and then rows
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Managment Reporter : Row data should not show for a particular coloumn

OK.

Have you tried changing the parameter to calculate first columns and then rows and vice to see if this makes a difference?
Mohamed Shuhaib 51 on at

Like (0)

Report

RE: Managment Reporter : Row data should not show for a particular coloumn

Hi Have restricted the cloumn Production for row 3093..3110

But in totals its showing up
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Managment Reporter : Row data should not show for a particular coloumn

Hi Mohamed,

Can you provide more information on your total and the calculations set up?

Some printscreens or report design sketches would help here.

Many thanks,

Ludwig
Mohamed Shuhaib 51 on at

Like (0)

Report

RE: Managment Reporter : Row data should not show for a particular coloumn

Hi Ludwig

I Tried This feature in Row .

But all the columns will be not shown ,

i Used the feature Coloumn Restriction .

i didnt show the particular coloum as the requirement , BUt the issue is the totals are including the values in that row of particular coloumn .
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Managment Reporter : Row data should not show for a particular coloumn

Hi Mohamed,

Have you tried using the NP feature for your rows and did that work out?

Ludwig