Your requirement can be done with multiple sheets and arranging them in dashboard. But directly in one sheet we cant do that.The excel kind of formatting cannot be done in tableau.
Thank you Tharashasank for the response ! My Product Category dimension would have multiple values and not limited to a number and we can't have static worksheets to handle this right ? If we go with this approach then we'll have to create multiple worksheets on the fly at run time and add them to the dashboard respectively.This seems to be harder to maintain and implement.
Any other thoughts ?
Exactly what you are showing in reporting is not possible directly from your data source. You need to do some data formatting on data.
First of all your reporting requirements are like excel so it is not directly achievable. You cannot show multiple headers i one worksheet. because tableau wont give you that feasibility.
this type of reporting is not supported by tableau