Add 2 Expressions + 1 dimension in pivot table

[elie_issa]

Dear Concerned,

I am trying to add a pivot table having 2 expressions (Average, Question Index) and 3 dimensions : Questions , Date , Group (Zara,Massimo Dutti , Others)

The 2 expressions should be calculated based on the first 2 dimensions Questions and Date

and another expression should show on the third dimension.

( below is a sample table)

Thanks and Regards,

Elie

maleksafa‌

[vishsaggi]

Can you share a sample to look into. And what values you want to see in your Zara, Massimo, others ? A sample output would help.

[elie_issa]

Hope the below will help:

The below two objects should be combined in one object as shown in the above requested table.

[vishsaggi]

Is it possible to upload a sample file to work on. ?Coz i do not know the expressions and data how it is coming.

Preparing examples for Upload - Reduction and Data Scrambling

[elie_issa]

Please Find attached the QVW reduced.

Let me know if you still need any other clarification.

[vishsaggi]

Try this may be?

[elie_issa]

The solution provided by you is correct but in our case the group dimension is dynamic and the data included in this dimension could change later on so we didn't use this solution in our report.

Thanks a lot and hope we can find another solution.

[vishsaggi]

What are the possible values you get in that Group? Can you share an example like how many you will have?

[elie_issa]

The values are populated in the script based on an excel mapping file.

so i cannot know in advance what are the possible values.