Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to create a pivot table similar to the way you can build in excel.
my table shows, by month, the expenses and output for each division - so the columns are Jan, Feb, Mar .... and so on.
In the first column, I would like to show the average of prevues year and I can't seem to get it right...
I attached an excel file with the data (Sheet "DB") and with the final table that I would like to display in my model.
In addition, I attached an exmple QVW, with the Pivot table that I manage to create,
I'm having trouble to create the column "Jan - Dec AVG", I would like to display it in a separate column and not in a row, is it possible?
also, it seems that the average is affected by the month, even though in the set analysis I wrote the month of the calculation
can anyone help me to create this column, please 🙂
Have a look at the following Design Blog post, it might help with the average piece at least:
https://community.qlik.com/t5/Qlik-Design-Blog/Average-Which-average/ba-p/1466654
Regards,
Brett
Thanks, But the blog is talking about internal grouping, my problem is different, Thanks anyway 🙂