Number of records in straight table, aggregated by certain columns

[Fquiroga95]

Hi, I would like to obtain the number of records of a table in a specific column, aggregated by week and segment.

This means for example, For week 2, Lower Midmarket segment, I have 4 records.

Week 2 for Small Business I have 3 records. And they must be in a column.

I am trying with

AGGR(NODISTINCT
NoOfRows(),Week,Segment)

But is not working, its giving wrong numbers.

I also tried with:

AGGR(NODISTINCT
Count(Vendor),Week,Segment) // in order to count another field, but it doesn't work either. 

[rwunderlich]

Assuming Week and Segment are columns in your straight table, try 

Count(Total<Week, Segment> Vendor)

-Rob

[Aurelien_Martinez]

Hi,

Perhaps with TOTAL

Count(TOTAL <Week, Segment> Vendor)

[Fquiroga95]

Thanks for your answer, anyway Its giving me the same result..

So this should be flexible depending the columns I put in the table. Maybe there are more "Vendor" records associated to a certain week and segment that I am seeing in the table ? Not all the data comes from the same table... I need the exact number of records the table is displaying.

[rwunderlich]

If you want to count the number of displayed rows -- which is the number of dimension combinations --  do it like this:

Count(Distinct TOTAL <Week, Segment> Week & Segment)

-Rob