2 Replies Latest reply on Mar 9, 2017 7:50 AM by Viji Ramesh

# Count the number of records for the 2 different sets of dimensions in a sheet

Hi all,

I'm struggling to figure out the solution of this problem for the last 2 days. I would really appreciate your help.

My table looks like this

 Zone State Type Count Date Zone1 State1 Type1 Count1 Date1 Z1 S1 T1 1 1-Jan Z1 S1 T1 1 1-Jan Z2 S2 T2 1 2-Jan Z1 S1 T1 1 1-Jan Z2 S2 T2 1 2-Jan Z1 S1 T1 1 1-Jan Z1 S1 T1 1 1-Jan Z1 S1 T1 1 1-Jan Z1 S1 T1 1 1-Jan Z2 S2 T2 1 2-Jan Z2 S2 T2 1 2-Jan Z2 S2 T2 1 2-Jan

I need the result like this

Zone        State       Type          Date        X
 Z1 S1 T1 1-Jan 1/6 Z2 S2 T2 2-Jan 2/3

Here, X is the calculated field which is the ratio of the number of records of the dimensions (Zone, State, type, date)/

number of records of the dimensions (Zone1, State1, type1, date1).

Thanks!

• ###### 1. Re: Count the number of records for the 2 different sets of dimensions in a sheet

Hello Viji,

The steps are,

2. setup relationship

3. create the calculated field and finish the table

For better understanding,

Hide all the fields end with "1" in one data source, then it looks like,

Hide all the fieds not end with "1" in another data source, then it looks like,

Regards

Lei

• ###### 2. Re: Count the number of records for the 2 different sets of dimensions in a sheet

Solved my issue. Thank you so much Lei!