How can I make this balancing

[Kinetic_analytics]

Hello great minds:

I want to create a report. where  first step I need to create 2 total. 

1) Total A

2) Total ( B to M)

3) Balance= Total A-Total ( B to M)

I have attached the .xls sheet for your information. Appreciate your help.

Thanks

[DataNath · Accepted solution]

@Kinetic_analytics one way I can think of doing this as long as this is your exact requirement. If the schema or target [Biz] can change at all then will have to revisit, let me know how you get on when testing with a larger dataset:

[binu_acs · Accepted solution]

@Kinetic_analytics One way of doing this

[Kinetic_analytics]

Thank you for helping me with my learning 5process.

[Kinetic_analytics]

Thank you for helping me with my learning process.

[Kinetic_analytics]

Quick question for you. 

Quick question for you, How do I select L on the sample tool? 

[Kinetic_analytics]

Quick question for you. How do I select "L" in the sample tool? in that case, n= what? 

[DataNath · Accepted solution]

@Kinetic_analytics if you wanted to select L for example, I wouldn't use the Sample tool personally, but rather something like the Select Records tool. From the main data set here I can see it's the 12th record so would just type 12 here:

If you wanted all but 12 in the other stream then you could just select the other records with something like so, where 12 is excluded:

You could also use 2 filters instead, one in each stream, where one holds the expression:

[Buz] = 'L'

and the other

[Buz] != 'L'

[Kinetic_analytics]

Appreciate your help.