Hi,

Create a calculated field in which break your age according to your requirement like if you want to create age group like 0-25, 25-50 etc then create a calculated field like below-

IF [AGE]>=0 and [AGE]<=25 then '0-25' elseif AGE]>26 and [AGE]<=50 then '26-50' else '>50' end

Put this calculated field into your worksheet & put your customer name there & convert it to count distinct measure. You can also create a calculated field with countd(Customer) & use it in sheet.

Let us know if you have further query. If this will not help then try to attach a sample workbook (.twbx) so that we can suggest you according to what you have in datasource.

Warm Regards,

Prashant Sharma - India | LinkedIn

Yes that is why I told you that every thing is depends upon what you have & what you want to show. Check the attached workbook & here I am using count() & countd().

One Suggestion from my side. Create the range of age not exact age ike what I have used in previous reply.

arm Regards,

Prashant Sharma - India | LinkedIn

In previous thread you do not want total but now you are showing that you want total also. Now, I am confused. In first reply you show me one sample data -

customerID1 ... order_date1  ... male ... 20

customerID1 ... order_date2 ... male ... 20

customerID2 ... order_date3  ...felmale ...25

customerID3 ... order_date3  ...male ...20

then you want to create a report like following -

***      age      no of orders      no of cases

female   25     1                         1

male      20     1                         1

male      20     2                         1    

I have created the same with same datasource in attached file -

In second reply you are showing another output -

***      age      no of orders     no of cases      no of total orders

female   25     1                         3                         3

male      20     1                         21                        21

male      20     2                         11                         22

male     20     3                             5                         15

Here, Can you please define "Number of Orders" & "Number of Cases" in this case. Do you want Number of Orders to be break? (means you want to count the number of cases where only 1 order is placed & where 2 order is placed & so on?). If you want something like that then first convert Agg(Number of Order) into dimension & create another calculated field with formula -

[Number of Orders]*[Number of Cases]

Also, check the attached file & let me know what exactly you want. If this will not work then create one excel with same data & also put the output you want.

It is always better to ask your all requirements in a single thread.

Warm Regards,

Prashant Sharma - India | LinkedIn