You could create a table (tblVolume) with one Field called Volume and the data contained in that file will be Volume. Something like:
LOAD * INLINE [
You could then use a List Box instead of a Text Box. If you do some formatting like hiding the Caption you might be able to make it look like a Text Box. By setting it up like this, you will be able to use triggers and functions like GetFieldSelections to determine if the user has clicked on the Volume text/list box.
I hope this helps!
thanks for helping! I think I have thought of a possible way myself, I guess none is faster than the other since I need that only on the uppermost level, as soon as the user drills down, I can use the diagram I have, only with different formulas.
I can create a variable (like >v_show_volume< and initially set it to 'N'. I can then add a trigger to that "volume" textbox to change that to 'Y'
=> I can query that variable in the formulas of my diagram to calculate either of two formulas, turnover or volume.
<=> The textbox I have always displaying the next_level_up in the drilldown group must then show "volume" instead of "variable turnover" as the uppermost level - which is probably a bit tricky because "volume" is not a dimension where I can make any sensible selection, every record has a volume, so I cannot easily make it part of my drilldown group.
<=> I also have to find some way to reset the variable to 'N' when the user drills back up to the uppermost level (that is, the "fixed/ variable/ specials" level, the turnover types of which I currently only have variable.)
Can anybody advise me in any way on how to do this?
Thank you very much!
I guess I can do it that way, with a variable. As for resetting it, I can just create another button that the user has to press once they have drilled back up and want to see the turnover figures again. I can even make that appear only when the uppermost level within my drilldown group is active, can't I?
I'd still be thankful if anybody could show me a better way, but that will do nicely.
Then I have to build a query in my "show_next_upper_level" textbox to query if
- the variable has a certain value
- and the currently active dimension is "Turnover_Type" (so I'm on the uppermost level)
=> in which case I will have that just display the fixed text "Volume".
The formulas in themselves are not problematic, I can query the variable to choose between two formulas.
My question for the moment is: Can I implement a "toggle switch" for a variable (to set the variable from the initial state 'N' to 'Y' upon clicking and back to 'N' with another click?
yes, that might work.
Maybe, however, I can solve this situation another way: I will enter a proposal with management - something I did not think I could, but I learnt yesterday that I can - to display the volume_figures on the y-axis from the beginning. That would make the whole thing a lot easier and I wouldn't have to bother about all this.
An annoying thing that I didn't think of this long ago, but how was I to know...
I will try, but I will keep your proposal in mind anyway. I'm sure I can use it eventually.
Thanks a lot!