Timeseries: % split of dimension

[#1]

Hi there,

I have a time series chart that looks at % of total sales for each salesman for each period. My dimensions are Opsdate and Salesman and my expression is:

Sum(Sales) / Sum (TOTAL <Opsdate> Sales)

My user wants me to adjust the chart so when he selects the a Salesman the chart just drops the other salesman and the selected Salesman % stays the same. With my existing formula it just shows a flat line at 100% because both the numerator and the denominator are adjusted by the selections. I want the denominator not to be impacted by the Salesman selection. So I tried the following formula:

Sum(Sales) / Sum ( {<Salesman>} TOTAL <Opsdate> Sales

But it doesn't seem to work. I played about with Aggr functions but have had no joy.

Thanks in advance

Max

[alexandros17]

Then use:

Sum(Sales) / Sum (TOTAL <Salesman, OpsDate> Sales)

[#3]

Hey Guys, I have added an example to show what I am trying to do if this makes it any clearer. So the issue is when I click on a Salesman the chart goes to 100%, I want it to stay with the same values just drop the unselected salesman from the chart.

Thanks!

[joshabbott · Accepted solution]

Try this:

Another thing I noticed is the color changes of the salesman.  Check 'Persistent Colors' on the 'Colors' tab so this doesn't happen if you don't want it to.

[#5]

Thanks Josh. The reason the formula didn't work in my live version is the field was called SalesMan and I had Salesman in my expression! Just one of those days. Much appreciated your help everyone.