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...

[kaushiknsolanki]

Hi,

If this is your real time scenario then try below expression for total.

=Sum({<Company={"$(=concat(distinct Measure,'","'))"}>}Sales)

Regards,

Kaushik Solanki

[kaushiknsolanki]

no it wont.

tell us your real scenario with real values.

Regards,

Kaushik Solanki

[qv_testing]

Please have a look my real example....

PFA, !

[qv_testing]

Please can you help on this...

[Anil_Babu_Samineni]

You can use Full expression rather Column(). check and let us know. Off course, In Conditional enable you need to manipulate same thing

[qv_testing]

No, it won't work because it will return whole sum.

i want to change based on Measure selection.

[Anil_Babu_Samineni]

I need to look attachment, Will help you for sure once i get access the app

[kaushiknsolanki]

Hi Can you tell us your expected output.

Regards,

Kaushik Solanki

[qv_testing]

If i make all Measure selections, my total coming proper.

By My scenario, if i make any selection

0-30 and Total,

0-30, 31-90 and Total

i want to total as well...

PFA,