Pivot Table Expression with Count and Total Count

[#1]

Hi,

Good day All!

I am trying to achieve the count(value) / count (total value). but i need to add some conditions on that.

I am attaching a sample file here.

Please help me to resolve this..

Thanks and Regards

RK

[lironbaram]

hi

have a look at the attach example

i changed the calculated dimension to regular dimension

and added the if clause to the expressions

[krishna20]

Hi,

Your First Expression : Count(REPORING_AIRLINE)

Your Second Expression : =([Reports Count])/ Count (TOTAL REPORING_AIRLINE)

Here Reports Count is the Label Name of first expression.

Please try this and let me know.