You have lame structure. You can remove all pre-aggregated totals (Overall), then your expression will looks like this:
sum(Value)/sum(total <Month> Value)
If you still want use Overalls then you need to duplicate it for each appropriate product per month like this:
ProductName Month Value Overall
Producta Jan 5 10
Productb Jan 2 10
Producta Feb 4 100
The expression will look like this:
But it is lame approach as well. Use the first one.
See example in attachment.
test%Totals.qvw 119.5 K
I need to create a market share report in which I have the information about our company & the industry total (overall), but not the information about the competition which makes up the overall number. In other words, I need to use the overall #.
The trouble with duplication would be in cases when in a particular month, our company did not sell anything, but there is an overall #.
On a related note, I am using a personal edition & I cant open your attachment. Would appreciate if you could explain in text what you wanted to show in the attachment.
You should have Industry Overall as lookup table then:
The data will look like this:
The Expression is:
for many Overalls per month
or if your are sure that the data for Overall will be just one value per month, then:
See updated attachment.
test%Totals.qvw 120.8 K