Need total value irrespective of Dimension

[shiveshsingh]

Hi

I need one quick help, my dimension is Products and expression is

if (Products='INTERNET_REV_PARTY' ,count  (Aggr(If(sum(Values) >= $(vInternet),DMU_NAMES),Products, DMU_NAMES)),

if (Products='NLD_REV_PARTY' ,count(Aggr(If(sum(Values) >=$(vInternet),DMU_NAMES),DMU_NAMES,Products)),

if (Products='MPLS_REV_PARTY' ,count(Aggr(If(sum(Values) >=$(vInternet),DMU_NAMES),DMU_NAMES,Products)))))

I need an expression, that would give total count, irrespective of dimensions but with the incorporated condition.

[sunny_talwar]

I need an expression, that would give total count, irrespective of dimensions but with the incorporated condition.

Not sure I understand? Would you be able to elaborate or share a sample?

[shiveshsingh]

Hi Sunny

This expression will give different values for  product dimension - -  - - - - - -INTERNET_REV_PARTY,NLD_REV_PARTY,MPLS_REV_PARTY

Now i need expression which would give result me total result, dimension should not impact the total

..something like below.

if (Products='INTERNET_REV_PARTY' ,count  (Aggr(If(sum(Values) >= $(vInternet),DMU_NAMES),Products, DMU_NAMES))  +

if (Products='NLD_REV_PARTY' ,count(Aggr(If(sum(Values) >=$(vInternet),DMU_NAMES),DMU_NAMES,Products))

+

if (Products='MPLS_REV_PARTY' ,count(Aggr(If(sum(Values) >=$(vInternet),DMU_NAMES),DMU_NAMES,Products))

[sunny_talwar]

I am still not sure I understand.. and what is confusing is the fact that you have the same expression for each Product under your if statement... why do you need if statement at all? Please spend some time to prepare a sample so that we can help you quickly. The way you are explaining will take you a lot of time to find answers.

Best,

Sunny

[shiveshsingh]

I have used if condition for each product because benchmark is different for all the products.

Here, just for testing i have used same variable but in actual expression it will be different.

Variable will be derived from getfieldselections from different list boxes.

I just need total count..hope this helps

[sunny_talwar]

hope this helps

Sorry to say, but it doesn't. Anyways I am sure someone more knowledgeable will surely be able to help.

All the best,

Sunny

[shiveshsingh]

Hi Sunny bhai

Please find sample along with output..

hope this helps.

[shiveshsingh]

Please help

stalwar1‌