Pivot Problem: Calc percentages on upper dimension totals

[hugmarcel]

Hi

see test.qvw example attached, I do not manage to calculate percentages correctly, where the percentages depend on upper dimension totals.

Thx a lot for any suggestion.

Note that the underlying data model must not be changed!

Marcel

[sujeetsingh]

See the sample

[#3]

Hi Marcel,

PFA...

[#4]

Hi Marcel,

Please find the attached qvw where the % #Bookings/ #Calls are displayed in %.

Regards,

Varsha

[hugmarcel]

Your answer is wrong, If I have 1 Booking for PROD1 and 3 Calls for NAME N1, Result should be 1 / 3 = 33%.
33% must be written as number in the empty cell of the pivot next to PROD1.

[hugmarcel]

I do not see any change in your test.qvw... have uploaded the wrong file?

Hint: If I have 1 Booking for PROD1 and 3 Calls for NAME N1, Result should be 1 / 3 = 33%.

33% must be written as number in the empty cell of the pivot next to PROD1.

[hugmarcel]

Your answer is wrong, If I have 1 Booking for PROD1 and 3 Calls for NAME N1, Result should be 1 / 3 = 33%.

33% must be written as number in the empty cell of the pivot next to PROD1.

[#8 · Accepted solution]

Hi,

Can you check if this was what you expected??

I have attached a qvw.

Regards,

Varsha

[kumarnatarajan]

Hi,

Try the below syntex.

Ex: Num( sum(COUNT)/count(Distinct CALLID),'#,##0.00%')

[hugmarcel]

Thanks a lot! Yes, the lower dimensions levels are correctly calculated.

Hm, Some numbers for the upmost dimensions are missing. E.g. 18/7, 12 / 4. How to add these?

And is it possible to suppress the empty PLAN, TOPC, NAME and PROD lines and keep the calculations?

Thx a lot for your help! Marcel