Forum Discussion

mur2za's avatar
mur2za
Frequent Visitor
10 years ago
Solved

Calculate and Plot Percent Mix

Hey guys, I am trying to create a line and column graph that plots sales by product (column) and the percentage of total sales of each product (line). The first part is obviously simple - I can't fig...
Need Help
  • Sean's avatar
    Sean
    10 years ago

    mur2za Yes to get the overall total at ALL levels - don't specify a column!

     

    Look at the picture and you'll see what I mean.

     

    Your function did exactly what you asked it to do => gave you the overall total but only at the Catgeory Level.

     

     

Sean's avatar
Sean
Community Champion
10 years ago

mur2za Yes to get the overall total at ALL levels - don't specify a column!

 

Look at the picture and you'll see what I mean.

 

Your function did exactly what you asked it to do => gave you the overall total but only at the Catgeory Level.

 

 

mur2za's avatar
mur2za
Frequent Visitor
10 years ago

Yup, that worked! I removed the "Category" column from my ALL function and it gave me the correct results!

 

Thanks for your help Sean!

 

Mur2za.