Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Comparisons for similar measurements
Actual vs. Budget _> money to money, qty to qty
Amount over time--> time to time
Top N category values (e.g. sales reps)
Measurement to follow its movements
Comparisons among items
Performance Trends---> Amount movements over time
Compare 2 dimensions--> Annual Comparisons over months
Comparisons for multi-measurements
Two measures ---> Currency amount and quantity
---->Amount and percentage
Two axis---->Left-axis and right axis for measurements
Two or more axis ----> Split axis horizontally
Comparisons of high level groups
One or Two measurements---> Sales and Profit
(Avoid a dimension with many values)
Ratio of measurements
Percentages Margin, Quota Achieved, YTD vs. Last YTD
(Avoid actual amounts)
Measurements act as dimensions (3D chart)
3D measurement chart Amounts, quantity and # of customers
Map chart Sales on geographical map
2 or 3 dimensions with a measurement
Multi-cross dim measures Amount over region and product
over time
Visual distribution measurements
What contributes how to the whole Regional Sales
Yes / No analysis
One dimension with multiple measurements
KPI Overview Cycle group dimension with Sales, Qty, Margin
Sort in any columns (No grouping)
Multi-dimensions with one or more measurements
Grouping of dimensions Product sales by item
Dimension across table Annual sales by months
Variance calculation using before( )
No repetition of the same values (grouped)
No end-user sort by double-click
s ur right
Good Post
Hi,
Also check this attachment.
Thanks,
AS
thank you amit.saini
Your Welcome
Hi rgv,
Please close this thread by making appropriate answer if you are satisfied...
François