Create chart pivot

bellesol — Sat, 16 Nov 2024 01:37:44 GMT

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 🙂

Re: Create chart pivot

Brett_Bleess — Thu, 26 Dec 2019 19:24:46 GMT

Have a look at the following Design Blog post, it might help with the average piece at least:

Regards,
Brett

bellesol — Thu, 26 Dec 2019 19:34:48 GMT

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