what total ( [ distinct ] expr for report ) does?

[venkiatmaruthi]

Hi

what the below syntax does?

Code Select Expand

total ( [ distinct ] expr for report )

I have one column 'Percentage' in my report

Code Select Expand

[Number of items]/total([ItemCount] for report)

I didn't understand what 'for report' do?

Becuase of this Percentage is coming in chart for my report when I run from Cognos connection. If I run from Report studio, its not coming.

I don't know but I feel for report is the reason for the above behaviour.

[blom0344]

Normally a measure/fact is aggregated against the set of dimensions used in a report. If you would want the grand overall total  than you can use the context 'for report'.  The distinct can be added to removes duplicates from the aggregate.

So, in your case , the total([Itemcount] for Report) should yield the overall total of Itemcount

[venkiatmaruthi]

Thanks a lot for you explanation blom0344.