# Metric Sheet to support any column dimension, not just dates **URL:** \ **Category:** Feature Suggestions\ **Tags:** visualizations\ **Created:** [August 20, 2024, 8:53am UTC](https://community.holistics.io/t/metric-sheet-to-support-any-column-dimension-not-just-dates/2036 "2024-08-20T08:53:03Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![jesko](https://community.holistics.io/letter_avatar_proxy/v4/letter/j/cdc98d/32.png) [@jesko](https://community.holistics.io/u/jesko)\ **Post date:** [August 20, 2024, 8:53am UTC](https://community.holistics.io/t/metric-sheet-to-support-any-column-dimension-not-just-dates/2036/1 "2024-08-20T08:53:03Z")
I would like to be able to use Metric Sheet with any dimension as a column, not just dates. Suppose I have a bookings table with the following columns: - booking ID - created\_at - campaign - order\_total I would like to be able to use campaign as the columns, and then add different measures as the rows, e.g. booking ID count, order\_total sum, etc. ---
**Author:** ![Tien\_Truong\_Tran](https://community.holistics.io/user_avatar/community.holistics.io/tien_truong_tran/32/1352_2.png) [@Tien\_Truong\_Tran](https://community.holistics.io/u/Tien_Truong_Tran)\ **Post date:** [August 20, 2024, 9:16am UTC](https://community.holistics.io/t/metric-sheet-to-support-any-column-dimension-not-just-dates/2036/2 "2024-08-20T09:16:35Z")
Hi @jesko, It’s Tien from Holistics support team. If I understand correctly, this is your desired metric sheet table ```auto | | Campaign A | Campaign B | Campaign C | | Metric A | | Metric B | | Metric C | | Metric D | ``` If this is the case, a pivot table will be more suitable for your use case. You could read more about Holistics pivot table [here](https://docs.holistics.io/docs/charts/pivot-table). Best regards, Tine ---
**Author:** ![jesko](https://community.holistics.io/letter_avatar_proxy/v4/letter/j/cdc98d/32.png) [@jesko](https://community.holistics.io/u/jesko)\ **Post date:** [August 20, 2024, 9:53am UTC](https://community.holistics.io/t/metric-sheet-to-support-any-column-dimension-not-just-dates/2036/3 "2024-08-20T09:53:32Z")
Hi @Tien_Truong_Tran, thanks for the quick response. Yes, that is my desired visualisation, ideally also with the ability to add row headings/indentations etc as with the metric sheet. However, I don’t think the pivot table can give us the result you suggest. A pivot tables only accept dimensions for rows, and measure can only be added as a value. The metric sheet visualisation is the only table type that allows you to add a measure as a row. Your example would look something like this in a pivot table: | | Campaign A | Campaign A | Campaign A | Campaign A | Campaign B | Campaign B | Campaign B | Campaign B | | --- | --- | --- | --- | --- | --- | --- | --- | --- | | | Metric A | Metric B | Metric C | Metric D | Metric A | Metric B | Metric C | Metric D | | Dimension A | | | | | | | | | | Dimension B | | | | | | | | | ---
**Author:** ![Tien\_Truong\_Tran](https://community.holistics.io/user_avatar/community.holistics.io/tien_truong_tran/32/1352_2.png) [@Tien\_Truong\_Tran](https://community.holistics.io/u/Tien_Truong_Tran)\ **Post date:** [August 20, 2024, 11:00am UTC](https://community.holistics.io/t/metric-sheet-to-support-any-column-dimension-not-just-dates/2036/4 "2024-08-20T11:00:49Z")
Hi @jesko , Thank you for your response. Let me discuss this with our product team. I will get back to you later. Best regards, ---
**Author:** ![minhthanh3145](https://community.holistics.io/user_avatar/community.holistics.io/minhthanh3145/32/816_2.png) [@minhthanh3145](https://community.holistics.io/u/minhthanh3145)\ **Post date:** [September 4, 2024, 10:15am UTC](https://community.holistics.io/t/metric-sheet-to-support-any-column-dimension-not-just-dates/2036/5 "2024-09-04T10:15:47Z")
Hi @jesko Sorry for the delayed response. After discussing with our team, we have noted this as a current limitation of our Pivot Table and have added it to our backlog for improvement. For now, Pivot Table can only help approximately achieve your desired result: ```auto | | Campaign A | Campaign B | Campaign C | | Metric A | | Metric B | | Metric C | | Metric D | ``` Following up on this, I want to clarify if the only gap between how Pivot Table currently works and your desired result is only in the column-row arrangement, or if there’s something else. In our discussions, we could think of two other reasons: - You have a lot of metrics therefore displaying metrics as columns in a Pivot Table wouldn’t be very readable/accessible. - You wan to use different dimensions in a Pivot Table (currently the dimensions in a Pivot Table are distinct values of a particular calculation). Your inputs would be of great help! ---
**Author:** ![jesko](https://community.holistics.io/letter_avatar_proxy/v4/letter/j/cdc98d/32.png) [@jesko](https://community.holistics.io/u/jesko)\ **Post date:** [October 4, 2024, 12:12pm UTC](https://community.holistics.io/t/metric-sheet-to-support-any-column-dimension-not-just-dates/2036/6 "2024-10-04T12:12:43Z")
Hi @minhthanh3145 , apologies about the late reply, I somehow missed your comment. Yes I suppose the main difference is the row/column arrangement. In a pivot table, we can select a dimension as the columns, but we cannot select a metric as the rows of course, only as the values, so currently a pivot table with multiple columns and multiple metrics (in the value field) will result in a very wid table with a lot of columns and only 1 row. We also like the ability to add subheaders in the Metric Sheet visualisation, so it feels like adding the ability to add any dimension and not just a date dimension to the Metric Sheet columns would be a great solution. ---
**Author:** ![di.hoang](https://community.holistics.io/user_avatar/community.holistics.io/di.hoang/32/421_2.png) [@di.hoang](https://community.holistics.io/u/di.hoang)\ **Post date:** [December 3, 2025, 9:15am UTC](https://community.holistics.io/t/metric-sheet-to-support-any-column-dimension-not-just-dates/2036/7 "2025-12-03T09:15:00Z")
Hi @jesko, We guess you might be interested in our **Show metrics as rows in Pivot Table** feature. Could you please check if it could address your case? [[Launched] Show metrics as rows in Pivot Table](https://community2.holistics.io/t/launched-show-metrics-as-rows-in-pivot-table/2411) 😊