Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!! 😄
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.