Sub headings with measures in matrix

[Anonymous]

Hello,

I am wondering if anyone has faced this issue,

I have got the sales data for a company, its got a few calculated measures (Revenue, quantity sold, AOV etc) for each time period, for example last 7 days, MTD, YTD, 

I am keen to have  a table shown below with the timeline on the top and then the measures underneath, however it is seeming very tricky,

Product	L7D	L7D	MTD	MTD	YTD	YTD
	Sales	Quant	Sales	Quant	Sales	Quant
Headphones...
....

Thanks for your help,

Kind regards,

Edward

[Anonymous]

Hi,

Thanks for your reply,

I am keen for a extra row of headings above, 

for instance 

I cannot seem to group the measures to make that extra row, of L7D, MTD and YTD,

Thanks,

Edward

[v-zhangti · Accepted solution]

Hi, @Anonymous 

Is this the result you expect?

Please check the attachment.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.