HOW TO CHANGE LABELS OF DIMENSIONS?

[#1]

Hey friends, i have a problem.

I have a CHART, with one dimension called COMPANY.

under COMPANY, i have the names of different companies, such as SONY, APPLE, DELL, HTC, NOKIA, SAMSUNG & PANASONIC.

how do i change the COMPANY label, such that, when i open the CHART, it only has APPLE and DELL under the COMPANY dimension.

So basically,

1) 1 CHART with a COMPANY dimension.

2) COMPANY : SONY, APPLE, DELL, HTC, NOKIA, SAMSUNG & PANASONIC.

3)modify COMPANY dimension such that, COMPANY only has APPLE and DELL.

4)ONLY CHANGE THE LABEL OF THE DIMENSION TO MAKE THIS WORK.

Can this be accomlished? THANK YOU!!! 😄

[#2]

Not sure what you mean by this. Do you only want APPLE and DELL to show in the graph, or only have a lable on the APPLE and DELL bars, but still see bars for the others?

I think you can do it via an if statement: If (COMPANY='APPLE' OR COMPANY='DELL',COMPANY,'N/A').

If you put that in the lable statement it should only put lables for those 2. If you use a similar statement in the expression it will only show data for those 2.