Forum Discussion

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

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.