Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have quite a peculiar requirement here not sure how to ahead with.
We developed some complex logic to show data dynamically in a pivot and straight table respectively.
Now question is can we use the end result of those tables as the data source to objects in another sheet of same report . for example.
I have 6 columns of which M1, M2 and Dim3 are calculated ones on some selection.
Table 1:
Dim1 | Dim2 | M1 | M2 | Dim3 | M3 |
x | x | x | x | x | x |
x | x | x | x | x | x |
x | x | x | x | x | x |
x | x | x | x | x | x |
x | x | x | x | x | x |
Now I want above result set to be used with column names and their values to used in another chart in a different sheet in same report but with no further calculation of M1, M2 and Dim3 their result sets should be lo
If you already data model setup then yes, many sheets we can use the same fields either dims or measures.. Can you explain little more to check
You cannot re-use expression results from one chart in another chart. What you can do is recalculate the expression in the other chart, using aggr() to specify the dimensions as required.
For example,
=max(aggr(your M1 expression, Dim1, Dim2, Dim3))
would return the max value of M1 from your sample chart.
-Rob