Calculate Contribution

[sunitha_chellaiah]

Hi All,

I want to calculate contribution % based on classification . Please go through the attachment.

Calculation used for Contribution % in the second table :

for e.g : consider the first product i.e. 'Order Delivery::Track my order delivery' 

4301 (from second table) / 23,169 (from 1st table , row classification total) * 100 

result should : 4301/23169 * 100 = 19%

Note : I have used filter in classification column in second table . so while calculating it is getting divided by only total of filtered classification. But it should get divided by the overall total of classification.

I am using : sum(# Tickets) / sum(total <date># Tickets )

Thanks.

[sunny_talwar]

May be ignore selections in the denominator expression

Sum([# Tickets])/Sum({1} TOTAL <date> [# Tickets])

[sunitha_chellaiah]

Its not working. Sill getting the same result.

[sunny_talwar]

Would you be able to share a sample to show your issue?