Restrict data through list box, let load with '0000, blank rows to be renamed as '0000

[nevilledhamsiri]

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

[nevilledhamsiri]

Please refer attachment for requested issues

Thanks

Neville

[nevilledhamsiri]

Could you please look n to this?

Regrds

Neville

[Digvijay_Singh · Accepted solution]

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))

));

[Digvijay_Singh]

Better expression for list box may be this one -

=if(not WildMatch(CLASS,'CH','EN'),CLASS)

[nevilledhamsiri]

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

[Digvijay_Singh]

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.

[nevilledhamsiri]

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

[nevilledhamsiri]

Something like below!

[Digvijay_Singh]

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.