Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need to create a pivot table in such a way that there should be pivot table for each location(where location is dimension). Please look into the image below..
In first image there are Operation,test name, measurement, and some calculation is done.. so i need each such kind of table for each location as shown in image 2. in image 2 celestica monterry and flextronics is locations..
Please share your ideas to solve it...
Thanks
Hi,
add loaction as first dimension in the pivot table.
Niranjan.
Hi,
If this was not a Pivot chart then using Trellis option in dimension tab you can do that.
For pivot there is no trellis.
You can do one thind use a variable as first dimension in pivot chart. This variable have selected value from input box.
This way you can show for each location but one at a time.
HTH
Hi shubhu,
can you please explain a bit more.. if possible with some steps/examples
Thanks