IF ATTR(data_type) = “ABC” then product_A_Share
Else if ATTR(data_type) = “XYZ” then product_B_Share
This error occurs when you aggregate measures and leave the dimensions disaggregated. You can use ATTR, MIN or MAX functions to aggregate them. Please have a read at this article:
Hope this helps with your future understanding.
I tried your solution with ATTR function but still getting the same error. I even tried using AGG function for Share but still does not work
Then do you have a sample workbook? Or some fake data.