Hi all,
1. I am trying to generate Quartiles that i can use in a pivot table(colouring) and then use those same quartiles in button for the user to filter the data by. To identify the Quatiles, i am using the code below but i cannot figure out where i am going wrong.
=if(Match(po_id, '$(=FirstSortedValue(distinct{<po_amount={"<=$(=Median({<po_amount=
{'>=$(=fractile(po_amount, 0))<=$(=Fractile(po_amount, 0.25))'}>}
po_amount))"}>} po_id, -amount))', '$(=FirstSortedValue(distinct{<po_amount={"<=$(=Median({<po_amount=
{'>$(=fractile(po_amount, 0.25))<=$(=fractile(po_amount,
0.5))'}>} po_amount))"}>} po_id, -po_amount))', '$(=FirstSortedValue(distinct{<po_amount={"<=$(=Median({<po_amount=
{'>$(=fractile(po_amount, 0.5))<=$(=fractile(po_amount,
0.75))'}>} po_amount))"}>} po_id, -po_amount))', '$(=FirstSortedValue(distinct{<po_amount={"<=$(=Median({<po_amount=
{'>$(=fractile(po_amount, 0.75))<=$(=fractile(po_amount, 1))'}>}po_amount))"}>} po_id, -po_amount))' ), po_id, Null() )
2. I also need to get top 5% of outliers based on sum( po_amount), year.
Thanks in advance.