1 of 1 people found this helpful
If you could attach a mock file as the excel file or workbook, we can show you to handle it. Yes, it is possible to achieve your desired result. Thank you
I can did a quick and basic calculation, but you can do different calculations once you get idea. See pic below and let me know if that is what you are looking.
Also, i have attached workbook for your reference.
What i did was to create a simple calculation by adding each measure and calling them total xxx. Since you have nulls, i have to use ZN to add them as 0 otherwise you will get everything as Null. Since you are joining all other data sources to Sheet1, now you can use dimension from Sheet.
I hope I was able to answer your question.
mock.twbx 49.8 KB
Thank you so much for really kind and quick response, and this educational workbook that is useful for me indeed as I am a starter
These are direct calculations of the data, but what I mean to do is something more tricky: a table that contains a new dimension consisting of the names of the tables ( please see the photo below as I changed the names of the tables from sheet1,... to AdNetwork1, ..., that is, the meaningful categories that I wish to have and that are actually the names of the files ) and that I will put in the row shelf, and a new measure MEASURE 1 that contains the values of the fields measure 1 in the first table and measure 1 in the second table, ... etc. and that I will use it in the column shelf.
The desired result:
Or, something like this, if I compute totals:
Thank you and best wishes..