Dear Telerik team,
is it possible to define more complex measures/aggregations than a simple sum for FLAT DATA?
... e.g. a calculating percentages, ratios, margins, etc. based on given datasource fields?
Simplified Example:
#these are the source data records:
Product Category SalesChannel Costs Revenue
P1 Mountain Bikes Internet 2000 3000
P2 Mountain Bikes Internet 1000 2000
P3 Mountain Bikes Store 3000 5000
P4 Mountain Bikes Store 5000 6000
P5 Accessoires Store 100 150
P6 Accessoires Internet 80 100
P7 Accessoires Store 50 60
P8 Accessoires Internet 10 15
# We want to show the gross margin for each combination of category and sales channel with the formula:
gross margin = (revenue-costs)/revenue
# This should lead to the following pivotgrid matrix as result:
All Sales Channels
Internet Store All Sales Channels
All Categories Mountain Bikes 21,7% 28,6% 26,2%
Accessoires 40,0% 27,3% 31,3%
All Categories 39,6% 27,3% 31,1%
Thanks a lot for your suggestions
and best wishes from Germany
Jens
is it possible to define more complex measures/aggregations than a simple sum for FLAT DATA?
... e.g. a calculating percentages, ratios, margins, etc. based on given datasource fields?
Simplified Example:
#these are the source data records:
Product Category SalesChannel Costs Revenue
P1 Mountain Bikes Internet 2000 3000
P2 Mountain Bikes Internet 1000 2000
P3 Mountain Bikes Store 3000 5000
P4 Mountain Bikes Store 5000 6000
P5 Accessoires Store 100 150
P6 Accessoires Internet 80 100
P7 Accessoires Store 50 60
P8 Accessoires Internet 10 15
# We want to show the gross margin for each combination of category and sales channel with the formula:
gross margin = (revenue-costs)/revenue
# This should lead to the following pivotgrid matrix as result:
All Sales Channels
Internet Store All Sales Channels
All Categories Mountain Bikes 21,7% 28,6% 26,2%
Accessoires 40,0% 27,3% 31,3%
All Categories 39,6% 27,3% 31,1%
Thanks a lot for your suggestions
and best wishes from Germany
Jens