Kris Erickson
New Member
- Joined
- Jul 14, 2006
- Messages
- 13
Hello, I'm looking for the end of the pivot table because I'm making a scatterplot on some data on the pivot table (which it won't let me normally do normally). Anyways I want to know when the end of the Pivot table occurs, so I can stop the for loop. And when the end of the most left entry of the pivot table ends, (When the next row field starts) and add a new series with each new 'topic' of the row field.
I have a few columns outside of the pivot table that are T/F and look for "total" and "Grand Total" and it gives me the right results.
But I was curious if there was an actual pivot table funtion that I could use. If not, I have the problem solved, but I was curious.
Thanks
I have a few columns outside of the pivot table that are T/F and look for "total" and "Grand Total" and it gives me the right results.
But I was curious if there was an actual pivot table funtion that I could use. If not, I have the problem solved, but I was curious.
Thanks