Hello Eveyrone,
I create a pivote table by using a cyclic group as dimension, such as Product, Product Line. I want show different product and product line for different year.
For example, for year 2009, I need to show Product1 and Product Line1, Product2 and Product Line2, Product3 and Product Line3. For 2010, I need to show Product1 and Product Line1, Product3 and Product Line3.
What is the best way to create this pivote table.
Thanks,
Dust
