Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear friends,
I have 2 doubts
Doubt 1: My table has the said fields (Country, Category, Volume, Month, Year, SalesValue) in my table. In Category tab i have two values (Beverages and Snacks).
1) I have created the filter pane with Dimensions as category. Is there a way to create two different types of charts for two different values and link it to filter pane
i)When i select Beverages, the chart should display a table (Sales Value based on country from Jan to Dec)
ii) When I select Snacks, the chart should display bar chart (Total volume from Jan to Dec)
Is there a way to link all 3 of the above?
Doubt 2: I am trying to create a pivot table of Percentage of total sales value for all the countries from Jan to Dec. Have used Sum (Value)/ Sum (TOTAL Value). However this is not giving the desired result.
Request for your support on the above 2 problems. Thanks.
For #1, you will want to create your Beverages tables and your Snacks barchart and put both in the same container object. In the container object,
select the Beverages table and in the "Show Condition" expression, use the following
if(GetFieldSelections(Category)='Beverages',1,0)
For the "Show Condition" of the bar chart, use the following:
if(GetFieldSelections(Category='Snacks',1,0)
It is unclear when you say Jan to Dec, if you are wanting monthly data for a selected year? Are you using a Year filter?
#2
I'm not sure of the exact behavior/results you are look for, bu if you have Country and Month as your dimensions, you may want to use:
sum(Value) / Sum(Total <Country,Month> Value)
For #1, you will want to create your Beverages tables and your Snacks barchart and put both in the same container object. In the container object,
select the Beverages table and in the "Show Condition" expression, use the following
if(GetFieldSelections(Category)='Beverages',1,0)
For the "Show Condition" of the bar chart, use the following:
if(GetFieldSelections(Category='Snacks',1,0)
It is unclear when you say Jan to Dec, if you are wanting monthly data for a selected year? Are you using a Year filter?
#2
I'm not sure of the exact behavior/results you are look for, bu if you have Country and Month as your dimensions, you may want to use:
sum(Value) / Sum(Total <Country,Month> Value)
Try this Way
Thank you very much for your response @GaryGiles. That worked for me. However for the second problem the solution that I needed was sum(Value) / Sum(Total <Country> Value). This expression gave the desired result.
Thanks for your response @Anil_Babu_Samineni