I am intending to display the properties of the dimension in a grid along with the dimension. If I add properties as line item then each line item is repeated across all the dimension elements, as the properties are tied to dimension members and they should not be repeating across dimensions. Below is the screen shot.. In this example my line item should be only amount and somehow I should be in position to display the dimension properties along with dimension. Happy to be on call as well. Need assistance.
Dimension (X) | Dimension(X) Property 1 | Dimension (X) Proprtery 2 | | Jan | Feb | Mar |
10050111001 | CC_10050 | Amount_USD | Amount | 100,000 | 100,000 | 100,000 |
10100111002 | CC_10100 | Amount_USD | Amount | 0 | 0 | 0 |
10050112006 | CC_10050 | Amount_USD | Amount | 500 | 500 | 500 |
10050211001 | CC_10050 | Amount_USD | Amount | 200,000 | 200,000 | 200,000 |