Can help me

[santharubban]

I have two Pivot tables one table is Taxonomy service and the other is Thershold please find in attachement.

Thershold value in taxonomy table should same for all months for Primary care taxonomy service similar for all service.

Primary care thershold value = 0.12

but Primary care thershold value in Taxonomy table value different value for each month.Its shouyld be same for all months.

Experssion here:

num(

(num((COUNT({1<NOT_IN_FR = {0},RPT_MON = P({<RPT_MON =,Month=,YEAR=,DOS=>} DOS),SUBMITTER_ID = ,TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,Month=>} DISTINCT ENCOUNTER_KEY)/

Count({1<SUBMITTER_ID = ,RPT_MON = P({<RPT_MON =,Month=,DOS=,YEAR=>} DOS),TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,Month=>}IPA_MEMBER_ID)),'#,##0.##')*12),'#,##0.##')

[#2]

Hi

Did you try TOTAL statement in your second expression.?

[santharubban]

can tell where to use total ?

[#4]

num(

(num((COUNT({1<NOT_IN_FR = {0},RPT_MON = P({<RPT_MON =,Month=,YEAR=,DOS=>} DOS),SUBMITTER_ID = ,TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,Month=>} DISTINCT ENCOUNTER_KEY)/

Count({1<SUBMITTER_ID = ,RPT_MON = P({<RPT_MON =,Month=,DOS=,YEAR=>} DOS),TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,Month=>} TOTAL IPA_MEMBER_ID)),'#,##0.##')*12),'#,##0.##')

[#5]

use aggr function with your month or date field.

[santharubban]

it didn't work..

[santharubban]

it didn't work..

[santharubban]

can anyone help me

[#9]

I haven't tried this but you just need to know where the TOTAL should be placed. TOTAL tells the expression to ignore the dimension/s similar to how {1} tells the expression to ignore selections.

Try this - (also use TOTAL for the numerator)

num(

(num((COUNT({1<NOT_IN_FR = {0},RPT_MON = P({<RPT_MON =,Month=,YEAR=,DOS=>} DOS),SUBMITTER_ID = ,TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,Month=>} TOTAL DISTINCT ENCOUNTER_KEY)/

Count({1<SUBMITTER_ID = ,RPT_MON = P({<RPT_MON =,Month=,DOS=,YEAR=>} DOS),TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,Month=>} TOTAL IPA_MEMBER_ID)),'#,##0.##')*12),'#,##0.##')

[santharubban]

I try the above expression,but it didn't work. I am getting total of all taxonomy services.