Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have 2 fields Channel and Sales..
In channel i have A,B,C,D,E and in sales i have 10,20,30,40,50
Now my requirement is if i select a channel for example i selected A and it is having value 10.. i need to get 10/10+20+30+40+50..
The same for B.. 20/10+20+30+40+50 = 20/150..
Please help on this..
Thanks
Bharat
if you are not using the expression in the chart then you need to ignore the filter for the denominator.
sum(Spend)/sum({<Channel =>}Spend)
use Bharat's expression in say a bar chart where the dimension is Channel. As indicated previously you should mark this as relative and probably also define the number format as %
SUM(Value)/SUM(Total Value)
Hi Manish,
Thanks for your reply..
I have given like this
=sum(Spend)/sum(TOTAL Spend)
But i am getting value as 1
Create the chart,
Dimension - channel
Expression - sum(sales) (check relative option for this expression)
Create a Chart/Table
Dimension
Channel
Expression
SUM(Value)/SUM(Total Value)
If you want in Text Box
You have to use
SUM({<Channel = {'A'}>}Value)/SUM(Total Value)
SUM({<Channel = {'B'}>}Value)/SUM(Total Value)
SUM({<Channel = {'C'}>}Value)/SUM(Total Value)
SUM({<Channel = {'D'}>}Value)/SUM(Total Value)
SUM({<Channel = {'E'}>}Value)/SUM(Total Value)
if you are not using the expression in the chart then you need to ignore the filter for the denominator.
sum(Spend)/sum({<Channel =>}Spend)
use Bharat's expression in say a bar chart where the dimension is Channel. As indicated previously you should mark this as relative and probably also define the number format as %
Hi Bharat,
Try this attachment,
Hi,
use this expression :
NUM(SUM(Sales)/SUM(TOTAL Sales),'##.0000')
Hi Bharat,
You also try this expression,
Sum(TOTAL{<Field1=>} Field2)/Sum(Field2)
Thanks Damian..This is exactly what i needed.