Market Shares per month

I'm rather new to Spotfire so may be asking obvious questions!

I'm trying to greate a simple chart with market shares for the selected products monthly.

The % of Total built in expression comes up with Sum([ScriptLineItems]) THEN [Value] / Sum([Value]) OVER (All([Axis.Color])) but this gives me the % share over the whole data set, and not the monthlies.

Previously in Qlikview I used the following expression: =Sum (ScriptLineItems)/Sum(total <ScriptMonth> ScriptLineItems) 

 

Attachments

AttachmentSize
Image icon correct_result.jpg35.64 KB
Image icon spotfire_result.jpg47.3 KB
Login