Skip to Content
0
Former Member
Feb 19, 2009 at 03:00 PM

Bex and WAD requirement in BI

22 Views

Hi all,

I have a very different requirement in Query from the client.Where the user is looking to see the quantity for 'not assigned' and also he wants to see the quantity for 'not assigned in total with other list if categories like packaging,fabric but he does not want the display of 'Not assigned' with other categories

Basically 'Not assigned' brings the total quantities inspected.

If I filter out 'Not assigned' then the value for 'not assigned' also gets filtered and is also not available in the total.

My objective is to have the value of 'Not assigned' in with other list if categories like packaging,fabric but the word 'Not assigned should not be displayed during the execution of the query.

Please see the example below:

Example

Inspection category total inspected qty faulty inspected qty Percentage

clothes 20 X%

fabric 60 X%

Packaging 30 X %

Not assigned 250

Total 250 110

Now the client wants the word 'Not assigned' not to be displayed but he wants the value 250 to be displayed. He also wants a new column percentage which should calculate the percentage of fault for each inspection category i.e for each row fabric,clothes,packaging.

This whole thing needs to be run in Bex and WAD.

Need your suggestions!!!!!!!

Thanks in advance

Regards

D