Compliance % Based on Dimension

[joshibabu_are]

Hi Guru's,

I want to display Course Status Wise Compliance % in PIVOT Table,

Here i want to show 89.80 in Both Compliance % Place

98.92 is showing wrong %.

Thanks,

Joshi

[adamdavi3s]

Just change your expression to match your dimension logic:

[joshibabu_are]

Hi Adam,

Thanks for your Time.

its working with selections but if i clear selections its not working as expected.

[adamdavi3s]

Hmm yes its a dimensionality issue, I will have to ponder this

Just an FYI but the data seems to have quite a lot of personal information in it so I have taken the qvw off my answer