If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Help with count function in DMR

Started by cognos05, 30 Mar 2015 03:51:51 PM

Previous topic - Next topic

cognos05

I am using count function in my report on 2 columns and if I sort my rep column then my report layout behaves in a odd manner.(sorting is done by clicking sort by ascending, also tried selecting reps and then click sorting and choose the account column and then say descending and used order function)

I have Distributor-> Regions-> Reps nested in rows and they r from same hierarchy with different levels.
Columns showing YTD, PriorYTD,YTD Change and sales as measure.

Now I am showing 2 calculated columns one will just give the number of accounts corresponding to each rep .

SO I have used the expression AccountCount : count([YTD] within set children(currentmember(rows hierarchy))

Second Expression Negative Account Count for each rep :  Count( [YTD]within set filter(children(currentMember(row hierarchy)),[YTD Change]<0))

Have I used the count expression correctly , is count supported in dimensional reporting ? On Sorting my rep based on Account count or negative count my data in the row gets collapsed and the rep data item is not shown or disappeared.

Any help on this is appreciated.

Thanks,
Nithya