Display Dimension Properties along with Dimension

AvnishGoel

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

AvnishGoel

@rob_marshall
Appreciate your quick reply. Your solution works. I really wish there is some way to use properties. We are un-necessary creating additional dimensions where there is no need.