10 Replies Latest reply: Jun 9, 2017 10:31 AM by Andrey Khoronenko

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.

• ###### Re: Add two Dimensions (quantities)

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

• ###### Re: Add two Dimensions (quantities)

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

I hope you understand.

• ###### Re: Add two Dimensions (quantities)

Can you pls attach example file

• ###### Re: Add two Dimensions (quantities)

Hi,

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

Regards,

Andrey

• ###### Re: Add two Dimensions (quantities)

Thans taj and Andrey,

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

Thank YOU!!

• ###### Re: Add two Dimensions (quantities)

Hi,

like this (look attached file)?

• ###### Re: Add two Dimensions (quantities)

Hi Andrey,

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!

• ###### Re: Add two Dimensions (quantities)

Hi Leo,

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