Forum Discussion
Help with correct total
Hi， Anonymous
If so, you can directly change the summary type of each column value, here you can use 'maximum'/'Average'/'Minimum' to get the result you want.
Best Regards,
Community Support Team _ Eason
I don't see the option for uploading itself even for one drive 😞
How do I do that please?
If you have the file in one drive you should be able to click share in one drive and create a link that anyone can access. Then just paste link below.
Thank you!
I used goog drive and hopefully, it works!
Here is the link with example dataset for concept purpose:
https://drive.google.com/file/d/1u08xEf1LhetTmZ5c9Hdzxyfh-845PiWv/view?usp=sharing
I worked on the combined table as described above. But I have also included individual tables Table 1 & Tabel 2 along with parts table in case we can link the 2 table with parts directly.
Thanks again for the support!
Hi,
In January, Part A01 was used in Models M1 and M2. So the answer should be 195+195 = 390. What is the problem?
Sales of A01 was just 195 in Jan. This is a part that goes into models M1 & M2. Thats why we have 2 rows showing 195 in each for different models
Hi, Anonymous
If you don't want the data to be aggregated, you can try adding 'Combined'[model] to the row of the matrix as well.
Best Regards,
Community Support Team _ EasonIt still aggregates right. I am looking to see 195 instead no matter if one model is selected or all.
Thanks!
