I have a huge data set from different excel sheets. I am building a pivot like salereport where I can filter certain "columns" and I present sale per product and per time periodes. Everything works well until
a want to add another layer
In "Screenshot before" everything is ok you can see that the sale is 42 421 560 in total for EGID 111134 and part T23 you also see above that there is 3 companies that sumerize total sale
in next "screenshot 2 " you only see one company where all sale is presented and this is not right. It should show all three companynames and total sale devided
a want to add another layer
In "Screenshot before" everything is ok you can see that the sale is 42 421 560 in total for EGID 111134 and part T23 you also see above that there is 3 companies that sumerize total sale
in next "screenshot 2 " you only see one company where all sale is presented and this is not right. It should show all three companynames and total sale devided