Skip to Content
0
Dec 20, 2019 at 05:25 PM

Excel Pivot table convert to WEBI Variable

178 Views

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!