Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
So I have a normal table that I have converted into a pivot table, and then I use Page feature so I can have as many sheets as the page feature filter (in this case, the filter is NOM_VENDOR_RESP). It does the x amount of sheets per NOM_VENDOR_RESP, but it doesnt filter my pivot table. So instead of showing only the data from ONE VENDOR, it shows me the full table, so I basically have x amount of sheets, with the same full table, but with the sheet names correctly.
Why am I not being able to fix this? I thought it would do it automatically but I guess I´m missing somehting.
My result: for example: 3 sheets with their names: Person 1, Person 2, Person 3, but in each sheet its the FULL TABLE with all the data, not filtered by Person1 data, Person2 data and Person3 data.
Thanks!
The solution would be to put pivot table and source table into single (the same) sheet together otherwise you are losing the link between source data and pivot table which is typical excel behaviour.
What you are doing is:
So the result you see are expected I would say.
cheers
Lech
The solution would be to put pivot table and source table into single (the same) sheet together otherwise you are losing the link between source data and pivot table which is typical excel behaviour.
What you are doing is:
So the result you see are expected I would say.
cheers
Lech