Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have following issues which are required to be learnt from you!
Number_1
Dimension with business code loaded '0000 as just 0. I need full 0000 to be loaded on the P/T
Number_2
Dimension with business code carries two blank rows, i need this two rows to be copied with '0000
Number_3
List box on Class code to be restricted with CH & EN codes being excluded from showing. How this is achieved with above two cases
Regds
Neville
May be this -
LOAD BRANCH_CODE,
CLASS,
Text(BUSINESS_CODE) as BUSINESS_CODE,
CF_TOTAL
FROM
[..\..\..\..\..\..\Downloads\RESTRICTED_BOX.xlsx]
(ooxml, embedded labels, table is Sheet1, filters(
Replace(3, bottom, StrCnd(null))
));
Please refer attachment for requested issues
Thanks
Neville
Could you please look n to this?
Regrds
Neville
May be this -
LOAD BRANCH_CODE,
CLASS,
Text(BUSINESS_CODE) as BUSINESS_CODE,
CF_TOTAL
FROM
[..\..\..\..\..\..\Downloads\RESTRICTED_BOX.xlsx]
(ooxml, embedded labels, table is Sheet1, filters(
Replace(3, bottom, StrCnd(null))
));
Better expression for list box may be this one -
=if(not WildMatch(CLASS,'CH','EN'),CLASS)
Thanks Digvijay,
Your solutions are absolutely fine! One more clarification please.
As you suggested in restricting some class such as 'CH', 'EN', if I am to restrict the same in the pivot table both class (EN & CH) together with their respective CF_TOTAL,what could be the set expression to be used?
Thanks
Neville
I think same expression works for pivot as well or this as well -
Please close the thread by marking correct/helpful answers if it helps or post further questions.
Should this expression to be applied on the class dimension as a calculated dimension?. If it is so only that classes are not shown but cf total being reflected against a null value
Thanks
Something like below!
I think you should not use CF_TOTAL as dimension? It should be a measure? Please let me know in case I am missing some requirement.