Hi there, I have two tables: one is a list (5,000 rows), second is a table (10 rows x 30 columns).
Can I merge both tables in pivot (axis x = list, axis y = table) and define a formula that uses values from both x and y axis inside pivot table?
I currently create pivot for both table and then just type in formula but that does not seem efficient. I also managed to get table together through data model but how to define formula for common part where I refer to value on x axis and values on y axis? Calculated fields are greyed out, there are only sets.
What if I had three tables? Three dimensional model with formula?
Can I merge both tables in pivot (axis x = list, axis y = table) and define a formula that uses values from both x and y axis inside pivot table?
I currently create pivot for both table and then just type in formula but that does not seem efficient. I also managed to get table together through data model but how to define formula for common part where I refer to value on x axis and values on y axis? Calculated fields are greyed out, there are only sets.
What if I had three tables? Three dimensional model with formula?