Skip to Content
0
Former Member
Oct 15, 2015 at 08:39 PM

issue with data display

30 Views

Hi All,

We have Summary report and detailed report, both are on BEx query. Both queries have 'Code' variable. selected two codes for summary report and below data is displaying in summary report

Country

Amt

C1

500

C2

1000

created a hperlink on country column using wizard (not through hyperlink syntax) .

Since it is BEx query, so passing Code_Key detail object to Code variable..

Issue is.. after creating hyperlink summary report data is changing like below as amount is not aggregating and displaying separately for each code.

Country

Amt

C1

200

C1

300

C2

450

C2

550

I tried to pass the code_key to code variable using Userresponse() like below then it is displaying correctly.

if(Userresponse("Code")="abc";"10";if(Userresponse("Code")="xyz";"20";"10;20")

But we have many codes and user can select any combination, so I think userresponse() is not the option. Can you please help me why it is not displaying aggregated data when Code_key detailed object is passed to ‘code’ variable? What I am doing wrong here to pass multiple values..?

Thank you,

Suri