Set analysis in Straight Table

[#1]

Hi,

I've got an issue unsolved

I've got three Types of shops:1,2,3

and 9 Shops that each of them belong to a type

for each shop I've got the sales

now I want in the chart itself to show the difference between certain shop to the shops of the same type

For example:

Shop A belongs to Type 1 and has 100 sales,

The Avg. of type 1 is 150, therfore the answer in shop A Line will be 150

I attached the file

thanks in advance for the helpers.

Jacob

[Nicole-Smith · Accepted solution]

Your expression should be:

avg(total <Type> Sales)

Correct file is also attached.

[alexandros17]

Here it is your document

let me know