need help in pivot table

qlikapple — Sat, 16 Nov 2024 18:00:46 GMT

Hi all, I need some urgent help

I have pivot table

Dimension as person id and the expression has how many Applications he has verified

I have taken 5% of the applications for each person id for every month

for the month of the September I have taken the expression as

=if(Count({<MonthYear = {"Sep20"}>}DISTINCT[Review ID])*0.05<=77,
Count({<MonthYear = {"Sep20"}>}DISTINCT[Review ID])*0.05,77)

Now I want to show the personids in the pivot table itself as rows in QlikView.

Please find the attached qvw, I need very urgent , can you please help me.

Re: need help in pivot table

gp_oconnor — Tue, 06 Oct 2020 13:45:24 GMT

Can you please provide some more details? Maybe create a mock up in Excel of what you want the pivot table to look like with a few rows?