Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
In sheet 1(Data): I've column data as Area, Country and Value. In other sheet I created pivot based on sheet 1
I've problem to split pivot table to another sheet based on value of Area.
Here I attached sample of my template in Nprinting.
Thanks for your answer n support
Hi,
have you tried like this way?
How to Use the Page Feature in Excel and PowerPoint Report Templates
It will worked if my data as straigth table, but in my case it show as pivot table in sheet.
Hi,
yes, refer to the attached sample project (i've used straight table, page & level with pivot table)
Hi Deva,
In your example,source table in sheet1 just one row not all data in table.
I've same issue like your sample, when I split sheet by Area (in your case is Year) it split sheet to all value of Area but result of pivot table is same as original pivot.
Hi,
I've used dummy data, your case it should work. if still not working would be able to share your mock app and expected output.
Thanks
Deva
Hi deva,
Here I attached my mockup app, I used all field in template nprinting.
Hi,
Refer to the attached output,