This content has been marked as final.
Show 3 replies

1. Re: Calculation by using Categories
meenu choudhary Aug 23, 2018 2:22 AM (in response to SAIKAT DUTTA)Hi Saikat,
Column "F" can be achieved by below logic:
{Fixed [Bucket]: sum([Number])}
But for column "H" i didn't got the logic on how you arrived at "21%" and "11%".

2. Re: Calculation by using Categories
SAIKAT DUTTA Aug 23, 2018 2:59 AM (in response to meenu choudhary)Ignore 21% and 11%. It is a text.
But my question was if you count the numbers in Category 12MEuro then it is 4 and Total number of Invoices in 15.So, I want to show 4 is how much of 15 in Percentage that lies wthin the bucket.i.e===>
4/15=27%

3. Re: Calculation by using Categories
meenu choudhary Aug 23, 2018 5:53 AM (in response to SAIKAT DUTTA)