need help on Ad-hoc report

[qv_testing]

Hi Community,

I have done simple Ad-hoc report,

if i make selections Dimension = Year and Measure= A,B,C and Total

here total working fine 1550,  total calculation A+B+C.

MY requirement, if i make single selection Measure= A and Total,  i have to show my total, my total not showing because,

i have written my expression Column(1)+Column(2)+Column(3),

and if i'm make selections A, B and Total, i need to show based on selection Total.

same as A, C and Total

How to write expression total ?

Thanks in Advance...

[stabben23]

Instead of using column() it possible to use the Expression it self without the total in the column.

RangeSum([0-30],[31-60],[61-90]) is a neat way to solve this problem.

[tresesco]

I agree, that would a neater solution. However, wouldn't that be a kind of static solution? What if the values change or increase in measure field.

[qv_testing]

Really Awesome Guys .

Your BRAIN working like Machines.