Total is coming incorrect

[mark123]

Hi,

When i am using total in summarize options to total a column , i am not getting the total of that column.

My model is relational model.

I have attached the output screenshot.


Thanks Mark

[Nagendar]

Hi,

When i am using total in summarize options to total a column , i am not getting the total of that column.

My model is relational model.

I have attached the output screenshot.


Thanks Mark

try to change property for the Query: Auto Group & Summarize : Yes to No
as well as check the Aggregate Function and Rollup Aggregate Function properties of the measure.

Thanks
Nagendar

[MFGF]

Hi,

When i am using total in summarize options to total a column , i am not getting the total of that column.

My model is relational model.

I have attached the output screenshot.


Thanks Mark

It looks to me like you have a serious problem with your reporting package. Would you expect all the detail values to be the same? It seems very unusual that they would be. I'd be asking the person who created the package what's going on here...

MF.

[bdbits]

It might be due to using values from two tables that do not have a relationship defined.