Hello,
I would like to porpose the following regarding formulas :
- beeing able to defined formulas in the line or column section (for widget "pivot table"). Functions like SUBSTRING, LEFT, RIGHT, or CONCAT in order to reformat the content of a dimension also beeing able to use CASE function (to build buckets).
- beeing able to use string function to define conditions to apply to a dimension.
ie :
CASE [Type]
WHEN "A" THEN price * 09
WHEN "B" THEN price * 08
ELSE price
END
Thank you
