Skip to Content
0
Former Member
Jan 25, 2016 at 06:03 AM

Restriction in analytic view

26 Views

Dear Experts,

We

I am facing a issue in analytic view. below is my requirement.

Del Doc No Item Item Category Qty 12345 10 KPT 12 12345 20 KPT 15 12345 30 KPT 20 12345 40 ZTPY 30 12345 50 ZTPY 25 12345 60 ZTPY 28

In the above scenario, if Item Category is Equal to'KPT' then only quantity should display, Other than Item Category'KPT' quantity should be '0'.

As per our business requirement data should be like below.

Del Doc No Item Item Category Qty 12345 10 KPT 12 12345 20 KPT 15 12345 30 KPT 20 12345 40 ZTPY 0 12345 50 ZTPY 0 12345 60 ZTPY 0

Please help me how to restrict in Analytic view.

Thanks,

Nag