can I change the pivot table chart like this? help please

Here is my design in DOMO.

image.png

below is what I want. the difference is at value area, I want the figures of month (Jan, Feb, Mar…) on the left, then % of month (Jan, Feb, Mar…) on the right. that is to say, I do not want the 1st column at value area in Number, the 2nd column at value area in %, I do not want this because it is hard for me to see the trend in number or %. I like all the numbers on the left for each month, % on the right. hope it is clear.

image.png
Tagged:

Best Answer

  • david_cunningham
    Answer ✓

    @Lu_zhang - because you have columns defined, the sort order within each column grouping is going to be the same. There is a potential way to get to the end result you want.

    You would need to restructure your data to create the groups you want. For example, you would need to have it in the following format. Note, you could also add a column for YEAR (you can also calculate month/year inside of a beast mode). The downside of this is that you'll need to do your aggregation inside of your ETL for value and percentage by month, and won't have as much flexibility in terms of changing the date grain/filtering. My candid advice is that you should keep it as you have it. Or if you really want to see side-by-side, create 2 pivot tables, 1 for values and 1 for percentages.

    Screen Shot 2024-06-03 at 6.00.47 PM.png

    You can then set up your pivot table like this.

    Screen Shot 2024-06-03 at 6.00.24 PM.png

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

Answers

  • david_cunningham
    Answer ✓

    @Lu_zhang - because you have columns defined, the sort order within each column grouping is going to be the same. There is a potential way to get to the end result you want.

    You would need to restructure your data to create the groups you want. For example, you would need to have it in the following format. Note, you could also add a column for YEAR (you can also calculate month/year inside of a beast mode). The downside of this is that you'll need to do your aggregation inside of your ETL for value and percentage by month, and won't have as much flexibility in terms of changing the date grain/filtering. My candid advice is that you should keep it as you have it. Or if you really want to see side-by-side, create 2 pivot tables, 1 for values and 1 for percentages.

    Screen Shot 2024-06-03 at 6.00.47 PM.png

    You can then set up your pivot table like this.

    Screen Shot 2024-06-03 at 6.00.24 PM.png

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**