Adding percentages to a Pivot Table in QlikView

[#1]

Hi,

I was wondering if any one would be able to help me.  I've created a Pivot Table within QlikView.  Is it possible to also add percentages within this table too?

I've attached an example.

Any help would be greatly appreciated.

Many thanks.

Rajiv.

[#2]

Hi Sunil,

I don't understand what you mean.  Could you send your output as a screenshot please?

Thanks

Rajiv.

[#3 · Accepted solution]

Hi All,

I've manage to figure out how to do this.

I created one expression which was count([Reference Number]) and this was my value at the top.

Then I created a second expression which was count(TOTAL <[Month Year]> [Reference Number]) and set this as a % and it worked.

Thanks all your assistance.

Rajiv.

[mvaugusto]

Very useful