qlikview formula to excel formula

[tripatiqv]

Hi All,

I have 3 dimension serial no, State, Itemcategoryname and 14 expression in qlikview pivot table.

Now we are  developing this report in nprinting and we need to write below formula in excel.

for expression 7 we are writing below formula in 

if(Column(4)='0.00',0.00,(Column(4)/
if(Dimensionality()=2,sum(TOTAL WEIGHTINMT),
if(Dimensionality()=3,sum(TOTAL<STATE>WEIGHTINMT),
Sum(TOTAL<STATE,ITEMCATEGORYNAME> WEIGHTINMT))))*100)

Please help in writing this formula in excel

[Sergey_Shuklin]

Hello!
Some data sample will give a hand with this task. Can you share a piece of data?

[tripatiqv]

Dear 

please find the sample qv application  and sample excel data

I need to write current month % share.

[Sergey_Shuklin]

Hello!

Please, check the attached file. I've added TOTAL row, for table without it - just exclude the outer IF-condition with CELL="TOTAL" check.