i have the following qvd.
in this qvd, PNOEX denotes the product nos.
for example i have the PNOEX values as
NO9539 & so on
i need to calculate the total sales ytd for a particular PNOEX value & to be displayed in a textbox like the following
how can i make it.
Please give suggestions
Not with a text box. A text box has a finite display area, and you won't get scrollbars if the text doesn't fit. Imagine that you have about 50 PNOEX-values...
Use a straight table with a two-line caption and cut down on the chrome. You can get it to look like a text box with decent behavior.
i didn't get your point 'cut down on the chrome'.
explain a bit more please.
how can i do that.
also i have only 9 PNOEX values. out of that, i need to display only three.
if it cannot be done in single text box, i can have three.
I meant to say that if you omit borders in a straight table, and color everything (cell backgrounds, captions etc.) the same, a straight table may start to look exactly like a text box. The advantage is that you'll only need a single expression with simple set analysis, while in a text box you'll have to use concat() and aggr() to manipulate the different text strings. The latter is not very elegant...