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 · Accepted solution]

since TOTAL ignores dimensions, to consider specific dimensions use:

TOTAL <dimension1, dimension2>

in your case try - TOTAL <'Taxonomy Group'>

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 <TAXONOMY_GROUP> 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 <TAXONOMY_GROUP> IPA_MEMBER_ID)),'#,##0.##')*12),'#,##0.##')

[santharubban]

Thanks Patrick....