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

Options

Here is my design in DOMO.

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.

Tagged:

Best Answer

  • david_cunningham
    Answer ✓
    Options

    @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.

    You can then set up your pivot table like this.

    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 ✓
    Options

    @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.

    You can then set up your pivot table like this.

    David Cunningham

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