Create chart pivot

[bellesol]

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 🙂 

[Brett_Bleess]

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

[bellesol]

Thanks, But the blog is talking about internal grouping, my problem is different, Thanks anyway 🙂