Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a question about dimension. In a chart table, I have three dimensions A, B and C(each corresponds to a field). There are many more fields in my data besides A, B, C and users can select and filter values for any field. Now, I want to apply user's current selected values only for A field and B field but not any other. All other fields' selections should be ignored. In my chart table, I want to have A, B as dimensions and then C as my third dimension so that each c field value satisfying A&B selections should be an individual row. How should write the calculated dimension for C? I don't want aggregation functions like sum()or count() as I simply want to display all c values. Is it feasible?
Thanks,
Melissa
Hi, I'm not sure if you can do that in a calculated dimension, but you can use A and B as dimensions and show C as expression using:
Only({<C>} C)
Hi, I'm not sure if you can do that in a calculated dimension, but you can use A and B as dimensions and show C as expression using:
Only({<C>} C)