Use filter value as variable

[Cintozonna]

Hello !

Here is my problem:

I have a file with 10 companies, with different kind of parameter : Name, Number of Engineer, Number of commercial, Number of HR,…

I would like to create a page that can compare 2 of them. Thus, I used 2 independent smart filter (editing relationships) for the same parameter: Name of the company.

Then, what I would like to be able is : Depending of the two company chosen, showing some interesting data that compare the two companies. For example : the difference of number of engineers, commercial, HR  …

I insist on the fact that I want to perform operations and not only show the values of each (what I already have)

Do you have ideas ?

Many thanks

Cinto

[v-yuta-msft]

Hi Cintozonna,

Can you give some tables with dummy data and clarify more details about how to compare the difference?

Regards,

Jimmy Tao