I have about 12 columns in a pivot and organized by reporting day, I want to add in a header that groups them together such “Daily” and then I have sales, units etc for Daily under neath it, another one for MTD with the same columns under it, and another for QTD. How can I do that?
@Matthew_Payne, please refer this https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Grouped-Table-Pivot-Table-Headers for grouping headers.
Do you have a formula where I can put metrics under a column name?
@Matthew_Payne there is no formula to put metrics under a column name, I can submit this as a feature request.