Count() in Report value even after drillfilter.

[system]

Hi,

I am having a report, where I am displaying the number of transactions for each product.

I have drill filters in the report on Customer, Product.

When I apply drill filters on customer, the count() value for number of transactions for product is changing.

I would like to display the number of transactions for that product irrespective of the customer context.

I tried to use NoFilter(), but this works only with filter conditions. This is failing when we apply drill filters.

Is there any fucntion or work around to solve this?

Thanks in advance.

Regards,
Gowtham Sen

---

GowthamSen (BOB member since 2006-08-31)

[system]

hi there!

you can use =count([Product]) ForEach([Product])

i hope it helps.

regards,
r.A.

---

R.A. (BOB member since 2008-10-28)

[system]

Hi, r.A., did you test your suggestion? When drilling is enabled your formula will only return a count of those values that are visible after the filter, not the total amount from before the filter. Setting a context with “ForEach” or even “ForAll” is not going to address that issue.

gowthamsen, are you on 3.x? If so, check out the NoDrillFilter() function instead of just using NoFilter().

---

Dave Rathbun (BOB member since 2002-06-06)

[system]

hi!

thanks for the reply Dave, i forgot the drill. you can add it in the formula, or just simply use NoDrillFilter().

regards,
r.A.

---

R.A. (BOB member since 2008-10-28)

[system]

Hi Dave,

I am using BOXIR2. Good that, BO XI R3 is supporting this.

So as fo now, I created a derived table in universe which precalculates the counts.

If there is any other workaround please let us know. I would like to know.

Thanks a lot!

Regards,
Gowtham Sen.

---

GowthamSen (BOB member since 2006-08-31)

[system]

Even I was not aware of the NoFilter() basics. .

What happens if you use the below formula:

=Count([Product] In Report)

Edit - I checked, it’s not working.

---

aniketp (BOB member since 2007-10-05)