Forum Discussion
Line chart with selected customers only
Hi,
See if my solution in the attached file helps.
Yes. To answer your question "where is the "total sales all customer" created?" that's up for you know, what goes there is the column or sum measure you are using to represent the numerical values. You won't need to include any selected customers in the formula, by using your filters and slicers, your measure will consider those as part of the row context.
Thank you ray_aramburo. Are you talking about create a new measure ? where is the "total sales all customer" created? those selected customers are dynamic, could be customer A, B,C or X, Y, Z depending on the user. So I am a little bit lost here how can I put the customers selected by slicers in the formula.
Super UserYes. To answer your question "where is the "total sales all customer" created?" that's up for you know, what goes there is the column or sum measure you are using to represent the numerical values. You won't need to include any selected customers in the formula, by using your filters and slicers, your measure will consider those as part of the row context.