Pivot Table Ratio

[#1]

Hi All,

Good Day.

I want to create a pivot table with one dimension and two expression. dimension is airline name and the expressions are incentive and percentage of incentive.

I have attached the format. My Dimesnion is airplane_name and expressions are sum(TICKET_INC)  and SUM(TICKET_INC)/ SUM(Total TICKET_INC)

I want to remove some airlines that i have written a condition in the dimension, but when i give the option suppress when value is null, i am not getting the 100% in total ration.

Could any one let me know whats the solution..

thanks and Regards

[MK_QSL]

What is the condition you have written in Dimension?

Without knowing that, It is difficult to give you answer..

[Gysbert_Wassenaar]

Try these expressions:

• SUM({<airplane_name={'*'}>}TICKET_INC)
• SUM({<airplane_name={'*'}>}TICKET_INC)/SUM({<airplane_name={'*'}>}Total TICKET_INC)

[#4]

Kindly find it as closed!

[qliksus]

If you are using a Straight table with the relative option checked this should work automatically

Or you may use the expression suggested above