Joel Horowitz
New Member
- Joined
- Aug 23, 2002
- Messages
- 34
Hye,
I am trying to do the following: I have data, which are arranged in something that would perfectly fit in a pivottable, however I am aware that there are memory limitations that make it impossible to see the table as I would like to see it.
My data is made of +-2.000 rows with a hierarchy of 6 levels (a little bit like 'Country','State','City', but with 6 dimensions in total). Due to memory limits, I cannot put all the fields as row fields, so I have to put 'Level1' and 'Level2' as a page field. The annoying thing is that when I set 'Level1' at a specific value, then the admissible values for 'Level2' are not automatically updated.
I thought of writing VBA code that would hide all values for 'Level2' that do not match the current 'Level1' value, but that would require querying the source data, which is quite heavy (unless I could do it in SQL even though the data is in the same workbook). Any suggestions or alternative?
I am trying to do the following: I have data, which are arranged in something that would perfectly fit in a pivottable, however I am aware that there are memory limitations that make it impossible to see the table as I would like to see it.
My data is made of +-2.000 rows with a hierarchy of 6 levels (a little bit like 'Country','State','City', but with 6 dimensions in total). Due to memory limits, I cannot put all the fields as row fields, so I have to put 'Level1' and 'Level2' as a page field. The annoying thing is that when I set 'Level1' at a specific value, then the admissible values for 'Level2' are not automatically updated.
I thought of writing VBA code that would hide all values for 'Level2' that do not match the current 'Level1' value, but that would require querying the source data, which is quite heavy (unless I could do it in SQL even though the data is in the same workbook). Any suggestions or alternative?