% in gauge chart

[divianjani]

Hi Everybody,

i have dimension as  sales office and  metric as Revenue, how ever I need to create a gauge chart for that?

how i need to display sales ofc wise revenue amount %  in gauge chart?

I hope anybody can help me

Thanks & Regards

Anjani

[arulsettu]

hi,

     can u post sample data source

[Anonymous]

first of all do you really need gauge chart in your scenario ...i think you can use pie chart or bar chart

gauge chart dose not use dimension ... only expression you need to provide..

Thanks

BKC

[petter]

Use TOOLS (menu) and select Quick Chart Wizard (menu choice on drop-down menu).

Then select NEXT and select GAUGE CHART .... it will guide you through it....

[divianjani]

your reply is fine, however my requirement is I need to show them into gauge chart only

[divianjani]

for ex:

Dim_Sales Ofc
anx
bbd
ccc

Met_Revenue Amount
2500

3500

4500

I need to show the %(percentage) of Revenue Amount for Sales ofc by using gauge chart ,

[arulsettu]

are u sure u need gauge chart. because gauge chart dont need dimensions

[Anonymous]

then you can use sum(Revenue)/sum(Total Revenue) in your expression and give then a list box (sales office filter)

so that they can select the sales office which they want to see the revenue.

Thanks

BKC

[arulsettu]

like this?

[divianjani]

hi , thanks for your reply
I show them like this , but its not giving correct %
top(max(aggr(sum([Total Margin])/sum(TOTAL [Total Margin]),[Inventory.Sales Office Number])))