Problem with Pivot tables

GbiKripka28 

@GbiKripka28 

Olá Gabriel!
One good solution would be to have a separate table with the energy and water consumptions per month (one row per month.) Then we would use Power Pivot to connect those two tables and that would allow us to create on pivot table grabbing information from those two data tables. I am leaving this tip here in case you want to explore the idea of learning Power Pivot.

Without that option, you could still set the water and energy costs on a separate table and then bring those values to your main table, divided by the number of products you have each month.

For example, for the energy usage, th formula would be:

=SUMIFS(Table2[Energy Usage],Table2[Year],[@Year],Table2[Month],[@Month])/COUNTIFS([Year],[@Year],[Month],[@Month])

where table 1 is your main table and table 2 is the table with the water and energy costs.

Please also see file attached.

I hope this helps.

Votos de um dia feliz! :-)