Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I want to Calculate the the Sum of total Demand by different dimensions(Material/Location/Material Desc ..etc) using the Period Label Filter.
Here I have to use Period Label Filter as my selection, If i have selected the current period as FY18 2017-12-31 P1W1 then the sum of total demand by each material should give me the Total 9 weeks demand (i.e, Current week (Highlighted Yellow)+ next 8 weeks(Highlighted Red) =9 weeks Total Demand by material). Period Label is Rolling with total of 52 weeks.
For Calculating the % field ,formula used = Each value of Sum of total demand/Grand total of Sum of total Demand
Any suggestion/help is appreciated.
Thanks.
Don't duplicate for one issue. We can use https://community.qlik.com/t5/Qlik-Sense-App-Development/Calculation-of-Rolling-period-by-8-weeks-to...