Unlock a world of possibilities!
now and discover the exclusive benefits awaiting you.
I am facing challenge to create particular pivot table and taking those values in text box.
Here i want to create a column with following conditions
1) if Qty sold Q1 FY 19 >0 and Qty mfg >0 then show same Qty mfg in all quarters
2) if Qty sold Q1 FY 19 =0 then show 0 Qty mfg in Q1 FY 19
3) if Qty sold Q1 FY 19 >0 and Qty mfg <=0 then show Qty mfg in last /max Quarter mfg value in Q1FY19 and rest quarters to show respective mfg value
4) then show all the summation of Q1 FY 19 mfg value in text box