Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

Attribute as column header in table

Hi all! I have a sales report that contains data for 10 weeks and that has this structure: Date | Week | Value Now I would like to use the week number as the header in a table visual. I know, t...
  • Ritaf1983's avatar
    1 year ago

    Hi joshua1990 

    In a standard table visual, there is no concept of “row vs column vs value” — each field is simply displayed as a column in the order it’s added. It doesn’t support pivot-like layouts.

    However, what you're describing — Date as row, Week as column header, and Value in the cells — is exactly what the Matrix visual is designed for. The Matrix provides a pivot-style layout where you can define rows, columns, and values.

    So if your goal is to display data in that structure, the Matrix visual is the right choice.

    Like in my example of months that can be weeks in your case

     

    If there’s a specific reason the Matrix doesn’t work for you, feel free to share a sample or mockup, and clarify what limitation you're encountering — we might be able to suggest an alternative workaround.

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