Add two Dimensions (quantities)

[#1]

Hi!

I need your help, I am new to this subject and I would need to know if it is possible to add the different dimensions of which refer to Quantities. Example: I have company A with X Sales (I have defined a dimension "quantityA")

With these data manage to make a Budget and its variation perfectly.

Into ANOTHER pivot table, I have company B where I also have defined a dimension "QuantityB".

I need to do, if possible, a third table (or another chart) where I can see the sum of Both Companies (amounts) I hope I can make myself understood.

Thank you.

[tajmohamed30]

have your tried adding third expression as =Column(1)+Column(2)

you can modify the column numbers as required, so the resulted form 3rd column(adding 1st and 2nd column in your table)

[#3]

Thanks for your answer.

The problem is that they are two different pivot tables. One for Company A and one for Company B.

I hope you understand.

[tajmohamed30]

Can you pls attach example file

[ahaahaaha]

Hi,

You can build a summary table at the download script level (see the attached file.) All comments in the script code.

Regards,

Andrey

[#6]

Thans taj and Andrey,

I'm loocking the sample attach, but, my qty fields have a differet names.

please, see attach.

Thank YOU!!

[ahaahaaha]

Hi,

like this (look attached file)?

[#8]

Hi Andrey,

Thank for your answer.

Your sample is great! but, I need apply this theory with these "medidas"

SUM

I don't the sintaxys in expression?

Hope you understand.

THanks friend!

[ahaahaaha · Accepted solution]

Hi Leo,

If I understood you correctly. In the chart we try leave one dimension: YTD Max Date.

Expression: Sum({<ANO={"$(=(max(ANO)))"}>}CANTIDAD) + Sum({<ANO={"$(=(max(ANO)))"}>}CANTIDAD2)

[#10]

GREAT!!!!!!!

Thanks very much Andrey!!!!!!!!!!!!!!!