Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear,
In the attached file there is a pivottable with class columns. Now i have a period table (2014/11 etc..) and a corresponding number for the order. Now i can build a class for the columns. Depending on the selection (3months/4months) I have what I want. But can i rename the class labels in the columns like the period (2014/11 etc.) ??
Thx in advance!
You could use dual() to create two values - a numeric value for the calculation and the string one for the label:
dual(num(class(PeriodeOrde,3,'p',vOffset)), class(PeriodeOrde,3,'p',vOffset))
Instead the bold-expressionpart you created the period directly or used these part within a pick(match()) on a further variable or similar.
- Marcus
You could use dual() to create two values - a numeric value for the calculation and the string one for the label:
dual(num(class(PeriodeOrde,3,'p',vOffset)), class(PeriodeOrde,3,'p',vOffset))
Instead the bold-expressionpart you created the period directly or used these part within a pick(match()) on a further variable or similar.
- Marcus
Marcus,
thank you very, very much, got it working!
Kind regards,
Bart
Marcus,
thank you very, very much, got it working!
Kind regards,
Bart