Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody
I use Qlik Sense iVm. Corporate Planning.
Have various problems,
1. I want to create a table with accumulated sales values. However, as I want to summarize several months, I can not put any fixed months into my formula.
2. I want to put the actual values of two dimensions (I have given in CP) into a formula. (E.g. Sum (Turnover_PC) Actual / sum (Turnover_PC)
However, I do not come to a suitable formula ...
3. I would like to calculate the share of an account group in the total turnover. Again, I do not find a suitable formula after many attempts
Can someone please help me with formulas?
If possible provide sample data with desired output to understand it better.