Hi, I have an excel sheet with a pivot table where it has 6 dimensions as conditions and 2 columns in the table.
Conditions- Fiscal year , Code - ALL, Desc-ALL , etc.
Table has 2 collumns. One is dimension - Code and other Measure column - Sum(Qty).
Could any one please help me to implement this pivoting in WebI variable? I was trying to create a new variable . Sum(Qty) where = provide conditions. I get weird errors.
Any help is greatly appreciated.
Thanks!