Say I want to calculate percent of total where total is a sum of rows meeting some filter criteria for the pivotgrid. Do I need to rebuild the grid each time the filter changes?
Hello Sam,
I am just checking the progress of this issue and was wondering if you managed to achieve your goal or if you need any further assistance on the matter.
Hi Stefan thank you for checking this. I found I must rebuild the grid to recalculate totals correctly.
Thank you for your post. I have been looking into it, but I am not sure that I fully understood your question. Could please give a more detailed explanation of the result you want to achieve and screenshots of the desired result, so I could be able to investigate your issue further for you.
Looking forward for your reply.