cancel
Showing results for 
Search instead for 
Did you mean: 

Filtering in BO

Former Member
0 Kudos

Hi,

I have data in excel.

Request_Team                  CreateDate             total

-----------------------------------------------------------------------

A                                        2/10/2015                    10

B                                        2/10/2015                    20

C                                        2/10/2015                    30

B                                        2/11/2015                    40

A                                        2/11/2015                    50

So, here i'm taking number of requesting team for february month. Eg: Request_Team (A) = 2, Request_Team(B)=2, Request_Team(C)=1

How can i implement this logic in BO or Xclesius

Can anyone suggest.

Regards,

Rajesh

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

You should be able to do something like this if you create a new table with Request team and the new measure:

=count([Request_Team])

If you want to add a column to the existing table, you need to change the context:

=count([Request_Team]) in([Request_Team])


This is not testet though, but it should work.


/Kris

Answers (0)