
Re: Help with Pivots/Dimensions
khadeer basha Jan 24, 2013 11:07 PM (in response to M J)PFA. I am not sure u got correct answer r not, Check that one , let me know in what way u want rather than that.

Test1.qvw 137.2 K

Re: Help with Pivots/Dimensions
M J Jan 25, 2013 8:16 AM (in response to khadeer basha)Thanks. Teh pivot shows all products.. I wanted to show only the total of the products in each state that has more than one price.
It should look like
1Jan, S1, 1 (since there is only one product in S1 that has multiple prices across stores in that state)
1Jan, S2, 2 (since there are 2 products in S2 with multiple prices across stores in that state)
Ideally, if I clock the first row, it should expand to show the individual products (P1 in the first case & P1 & P2 in the 2nd case).

Re: Help with Pivots/Dimensions
M J Jan 25, 2013 8:16 AM (in response to khadeer basha)Thanks. The pivot shows all products.. I wanted to show only the total of the products in each state that has more than one price.
It should look like
1Jan, S1, 1 (since there is only one product in S1 that has multiple prices across stores in that state)
1Jan, S2, 2 (since there are 2 products in S2 with multiple prices across stores in that state)
Ideally, if I clock the first row, it should expand to show the individual products (P1 in the first case & P1 & P2 in the 2nd case).

Re: Help with Pivots/Dimensions
M J Jan 25, 2013 8:16 AM (in response to khadeer basha)Thanks. The pivot shows all products.. I wanted to show only the total of the products in each state that has more than one price.
It should look like
1Jan, S1, 1 (since there is only one product in S1 that has multiple prices across stores in that state)
1Jan, S2, 2 (since there are 2 products in S2 with multiple prices across stores in that state)
Ideally, if I clock the first row, it should expand to show the individual products (P1 in the first case & P1 & P2 in the 2nd case).

Re: Help with Pivots/Dimensions
M J Jan 25, 2013 8:16 AM (in response to khadeer basha)Thanks. The pivot shows all products.. I wanted to show only the total of the products in each state that has more than one price.
It should look like
1Jan, S1, 1 (since there is only one product in S1 that has multiple prices across stores in that state)
1Jan, S2, 2 (since there are 2 products in S2 with multiple prices across stores in that state)
Ideally, if I clock the first row, it should expand to show the individual products (P1 in the first case & P1 & P2 in the 2nd case).

Re: Help with Pivots/Dimensions
M J Jan 25, 2013 8:17 AM (in response to khadeer basha)Thanks. The pivot shows all products.. I wanted to show only the total of the products in each state that has more than one price.
It should look like
1Jan, S1, 1 (since there is only one product in S1 that has multiple prices across stores in that state)
1Jan, S2, 2 (since there are 2 products in S2 with multiple prices across stores in that state)
Ideally, if I clock the first row, it should expand to show the individual products (P1 in the first case & P1 & P2 in the 2nd case).

Re: Help with Pivots/Dimensions
M J Jan 25, 2013 8:22 AM (in response to khadeer basha)Thanks. The pivot shows all products.. I wanted to show only the total of the products in each state that has more than one price.
It should look like
1Jan, S1, 1 (since there is only one product in S1 that has multiple prices across stores in that state)
1Jan, S2, 2 (since there are 2 products in S2 with multiple prices across stores in that state)
Ideally, if I clock the first row, it should expand to show the individual products (P1 in the first case & P1 & P2 in the 2nd case).
