I have a hierarchy like the following,
sales regions (20+)
sales personnel (300+)
also when people view the report there is rls, and depending on who logged in some people have access to 100+ dealers, and some people have acces to only 1 dealer.
what I wanto to do is, I have a column chart displaying sales information in sales region / dealer / sales personnel detail. I want to change X axis dynamically based on number of dealers in the report. so if someone who has authorization for 2 dealers viewing this report, i want to display this column chart with sales personnel in the X axis (probably 5-6 items). if someone who has authorization for 100+ dealers i want to show the same chart in sales region detail in X axis (probably 9-10 regions). if someone with access to 6 dealers I want to display the chart with dealers on the X axis.
note : I tried field parameters, but couldnt get what i wanted. I thought creating a table and filtering parameter table with this one but it didnt work, because when I create the table, number of dealers is always the same, overriding rls.