Hi,
I have table:
Month, year, cost name, cost value, product group, product name
Each product is having its group and it costs and we also have one group: "unsorted" that is having costs for everything that is not directly connected to product like: water, electricity, amortisation of building and etc.
We have 5 product groups and we decide to split this unsorted cost to product group by key factor: 20, 25, 35, 15, 5%
How to do sort data that in pivot or any other view we can have option to show unsorted as group and with button option to include it in other groups by key % so its show true cost of each product groups?
Thanks
