Merge and split header in straight table

[#1]

I have straight table with two expressions for each month  resulting in 24 expressions sample of resultant view is below

I'm trying to obtain the as shown below

Thank you in advance community.

[sunny_talwar]

Use calculated dimensions

1) SubField(Month, '-', 1)

2) SubField(Month, '-', 2)

[Anil_Babu_Samineni]

Can you share application?

[#4]

Value1, Value2, Value2... is from one dimension. and there is two expression for each month

[sunny_talwar]

Not sure I understand...

[#6]

Sorry about that Sunny. Let me  try to make it clearer here. So I have a straight table where i have selected one field as a dimension and in expressions field i have 24 expressions. This produced a view like the first one in my post. Now I was trying to merge the Label as shown in the second image. 

[sunny_talwar]

Not sure how your data looks like, but you should be able to get the above view using pivot table with 2 or 3 dimensions. You might need to get in synthetic dimensions, but it would be difficult to say much without seeing the raw data

[Anonymous]

hi Naveen，

Did you  solve this problem ？