Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I want to show region wise percentage
i am trying to create one chart
like this type but i dont know how to develop
could some one help me to develop this chart
are any Example of QVW also better to understand for me
Thanks In Advance
Niranjan
see attachment
Hi Niru
to show %, just tick "relative" in the properties, tab "expression"
best regards
chris
Hi,
But i am trying create like That Circle chart
=
Round((
Sum ({< [Hierarchy 2] ={'GWM Operation'},[Hierarchy 2]={'GIM Operation'} >} [Actual Dollars])
/
Sum ({< [Hierarchy 2]=>} [Actual Dollars])
)
I am using this expression,
is there any example for like that circle chart showing percentage
BestRegards,
Niranjan
Guys any Idea...
Hi Niru
try this
to display % of sales in region wise, just tick "relative" in the properties, tab "expression"
or else upload u r file.
Regards
Chandan
You can make this type of charts by the use of the Pie charts and Load a Dimension selection table also
Eg:-
LOAD * Inline
[Year,Sales
2010,45871
2011,34567
2012,34346
2013,56568
2014,453453];
Dim:
LOAD * Inline
[Selection
Numeric
Percentage]
1. Then follow the instructions take pie chart Your dimension here i explain with Dim- Year
2. Then Expression Sum(Sales) and make this expression as relative.
3. Then select style from the properties.
4. And adjust your legend by the pressing ctrl+Shift key and by red lines on the chart make legend in the centre of the chart.
See the attached sample snap
And add the list box Selection below the chart
see attachment
Thank you so much guys
always you community guys are rock ..