-
1. Re: Question on calculation on same column
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
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
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
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
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