5 Replies Latest reply on Sep 26, 2018 1:24 AM by Kashish Bhola

    How to create a column to show the average of sales for each quarter along with the sum(sales) by Year, Quarter and months? Below I have an image of what is needed using sample super store data. Can anyone please help?

    Unmesh Panigrahy

      In this problem I need to show total sum of sales for all the Sub-Categories by Year, Quarter and Month. Along with it I want to see the quarterly average for each sub-category. I can create the average in a separate sheet and bring them together in the dashboard (may not be the best solution) but how to show that in the same sheet?