Currently, the measure function provides information only for the current value and accumulator. Hence only sum accumulation (reduction to be more precise) can be done. We will improve this for the upcoming RTM release of Kendo UI.
As to the specific questions, could you please elaborate more, for instance, on the "Internet" measure calculation? Let's pretend that you have a dedicated column that holds the "gross margin" calculation. How do you expect to produce the 21,7% value for the Mountain Bikes if you are using the value from this additional column? In other words, you've got those items:
Product Category SalesChannel Costs Revenue GrossMargin
P1 Mountain Bikes Internet 2000 3000 0.3333
P2 Mountain Bikes Internet 1000 2000 0.5
How will the "21,7 %" value be calculated?
As a side note, in term of performance, it will be better to calculate the Gross Margin
values on the server using an additional column as it is faster than doing the same operation on the client.
Thanks in advance for the clarification.
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI