-
1. Re: Question on calculation on same column
Dimitri.B Feb 12, 2013 4:14 PM (in response to primsu.achujacob)1 of 1 people found this helpfulYou can try something like:
SUM(IIF([Shop Name]=='Shop A',[Sales],0))/SUM([Sales])
-
2. Re: Question on calculation on same column
primsu.achujacob Feb 12, 2013 6:20 PM (in response to Dimitri.B)Hi Dimitri
Thanks for the reply. However i have not just one but many shops. Hence writing a condition will not be feasible.
-
3. Re: Question on calculation on same column
Joshua Milligan Feb 12, 2013 6:24 PM (in response to primsu.achujacob)primsu,
You can use a quick table calculation that is the percent of total. In the visualization, select the Sales field, right click and select "Add Quick Table Calc".
Joshua
-
4. Re: Question on calculation on same column
primsu.achujacob Feb 12, 2013 7:04 PM (in response to Joshua Milligan)Hi Joshua,
I use the same but it always returns me 100% since it does not take the total of all the values in that column.
-
5. Re: Question on calculation on same column
Joshua Milligan Feb 12, 2013 8:13 PM (in response to primsu.achujacob)primsu,
Have you tried the different options for the way the table calc is calculated? I'm guessing if it is a column you may need to select "Compute using: Table Down". But it's hard to say without seeing exactly what you are working with. If that doesn't work, you may need to post a screenshot or a packaged workbook.
Joshua