How to hide rows of pivot table based on condition.
I have data like below
I wan to create a pivot table like below when FLAG=1. but this condition I want to use in UI level not in Script level.
(Because I have other object which needs to have total data)
Resulted - pivot: (Note: here in list box I selected 1 as Flag so that result is correct. but I don't want to do like this. by default Pivot need to be displayed like below without selecting Flag=1 in List Box)
You can check this pic in WORD file plz.
I have attached sample data and Qvw file. please help and attach the resulred qvw to the reply.