total curve on graph

Hi chestercas ,

You can use SELECTCOLUMNS() or ADDCOLUMNS() to create multiple tables containing only dates, values, and categories in three columns. Then create a table with all the dates, add a column with the category "total" and a column with the total values of the other categories, and use the UNION() function to create a new table with all the data, placing the date column of the new table on the x-axis, the values on the y-axis, and the categories on the [legend].

Best Regards,

Neeko Tang

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