Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Create Page Level with Pivot table inside

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

7 Replies
devarasu07
Master II
Master II

Anonymous
Not applicable
Author

It will worked if my data as straigth table, but in my case it show as pivot table in sheet.

devarasu07
Master II
Master II

Hi,

yes, refer to the attached sample project (i've used straight table, page & level with pivot table)

Capture.JPG

Anonymous
Not applicable
Author

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.

devarasu07
Master II
Master II

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

Anonymous
Not applicable
Author

Hi deva,

Here I attached my mockup app, I used all field in template nprinting.

devarasu07
Master II
Master II

Hi,

Refer to the attached output,

Capture.JPG