I am struggling with getting the proper data to display within my bar chart. I want to display the bottom 10 product lines we have by revenue. When I add a limitation to the Dimension (Product Line), I cant seem to have it display the bottom 10. We have several product lines that come in at 0 at the present time due to data not being filled in.
So, when I limit by fixed number & bottom 10, I only get the 0's to display. When I then uncheck display zero values in the add on, data handling area, I get an error that says "The selections generated no data for this chart".
Please help me with this one - we have been trying to fix this for quite some time.
At this time, I do not think so...we are still trying to solve this without sampling.
For somebody who is trying to solve this for quite some time, I would have thought would have learned there lesson that some problems are difficult to address without having to take a look at a sample....
But if you still want to try a little more... I am good with that, I will wait for the time when you think it is appropriate to share a sample.
I am exploring options before venturing down the sample route. This issue does not seem to be difficult to explain without supplying sample data, is there something you are not understanding from my issue posts?
I understand the issue, but I just don't know how your data looks like, how are you connecting different fields and what are you getting more selection in business segment and what you are hoping to see after selection
I will explain here and lets see if we can shed some light.
So, I have a bar chart that with no limitation shows about 100 product lines total. about 20 of them have data filled in and are displaying, numbers like 2,300, 3,400 etc...
Now these product lines are categorized under product units (and there is about 10 of these that all the different product lines belong to), then those product units are categorized under main business segments. (there are 4 main business segments)
The data is setup in the table by revenue (measure) and product line (dimension).
What we want to see is the bottom 10 product lines no matter what filter is applied. Right? So, if I sort by overall business segment, I would like to see bottom 10 product lines by revenue across all product units. if I sort by an individual product unit, bottom 10 or as many as there for that product unit.
We have filters for business segment, product unit, and year (I don't think this applies)