Report Studio - Summing of the Price Margin %

[Meeth_Cognos_BI]

I have a Cross tab Report, with Year and Period as Columns and Product and Form as Rows and Price Margin (PM) and Price Margin Percentage (PM%) as Measures. I grouped Product and I did Total for Price Margin, however, the tool is also summing the PM%. I don't want to see the Total for PM%. How can I achieve this in Report Studio and in Workspace Advanced 10.2.1.?

Thanks!!

[IceTea]

To clarify:

You don't want to see the "Total" for PM% but some other type of aggregation for this measure
OR
you don't want to see any aggregationfor PM%?

In second case, just edit properties of the corresponding crosstab cells and hit "define contents = Yes"

[Meeth_Cognos_BI]

Thank you for helping me out.

As you mentioned, it is the first case which I am trying to apply in the report. I don't want to see a total for PM% as the tool is summing the values and showing the Total value as "163% or 110% or 150%" at times which is incorrect.

The second option which you mentioned is applicable only in Report Studio but not in Workspace Advanced 10.2.1. If in case there is no other way and if I am forced to use the second option, how should I apply that in Workspace Advanced 10.2.1??

Thanks!!

[IceTea]

Ok, got it.

by going the first case way you seem to have the wish to get some other kind of aggregate on this measure, where "Total" is the wrong function.

Did you give "Automatic Summary" a chance in your report? At the end of the day, this doesn't use the "Total" Function but the "Aggregate" function. Especially if "PM%" is a calculated measure (which is not known at this moment) this could bring you to success.