Grouping Issue

[jyothish8807]

Hi All,

I am stuck with a requirement: I have a table like this below. I want to group the sum on my Type, if i select a Master then final Sale should be his Sale and Group Sale should be his slave sales and if i select a Slave then Final sale should be his sale and Group sale should be '0'.

Name	Type	Sale
A	master	1000
B	slave	236
C	slave	334
D	slave	321
E	master	2000
F	slave	324
G	slave	234
Requirement:
If I select Name=A			if I select name=B			if I select name=E
Final Sale	1000		Final Sale	236		Final Sale	2000
Group Sale	891		Group Sale	0		Group Sale	558

Regards

KC

[Gysbert_Wassenaar]

Where's the data that links masters and slaves to groups?

[jyothish8807]

Hi Gysbert,

I dont have any data other than this linked to it. According to the table all slave mentioned below the master falls in his group. So i am trying to bucket them.

Regards

KC

[jyothish8807]

Final Sale and group sale are expression i need to create.

Regards

KC

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[jyothish8807]

Thanks a lot Gysbert, you are awesome

Regards

Jyothish KC

[anbu1984]

Check this app

[jyothish8807]

Thanks a lot anbu, even your solution worked.

Regards

Jyothish KC