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