Forum Discussion

motto's avatar
motto
Regular Visitor
2 years ago

Add extra column to the matrix

How do i add a new column to a matrix, the column will sum up daily sales for the month.

3 Replies

  • Hiiii motto 

    Please add the month name in column and add measure in values as shown in the image below

     



    If this helped you out please thumbs up and accept it as solution!!

     

  • Can you not simply drag a field from the Fields list to the "Add data fields here" part of the Visualization?

  • motto's avatar
    motto
    Regular Visitor

    This is what i want to come up with. I have a line list of people and the date they were seen. i want to add a column for the target they have to meet. and then populate the daily reachas  seen in the month of march for example. Add another column to sum all the vallues with that period eg sum of number from Jan to March and call it Progress.

    i only manage to do the following