Hi,
I have a straight table that I'm converting to a pivot table in Nprinting to get subtotals. Doing this works fine when filter is set to show one sheet pr (my case ID). I'm also trying to have a front sheet showing a total for all ID's. Everything is working fine, except for my precentage. It seems to either take the sum of all ID's or if I use average it will take the average percentage instead of just = 'current yr sales' / 'prev year sales' -1.
I've tried adding a calculated field, but that throws an error. Does anyone know how to solve this?
![qliknewbie_1_0-1657541287708.png qliknewbie_1_0-1657541287708.png](https://community.qlik.com/t5/image/serverpage/image-id/83796iDAE2ACBACC5B484C/image-size/medium?v=v2&px=400)
![qliknewbie_1_1-1657541616834.png qliknewbie_1_1-1657541616834.png](https://community.qlik.com/t5/image/serverpage/image-id/83797i2AEABB3A81B1A62E/image-size/medium?v=v2&px=400)
Thanks so much!