Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a stacked bar chart which i want to show the top 5 products by market share for each year. I am failing to format the table so that it shows the top 5 products by market share for the various years in the data set. An example application is attached. Please assist.
maybe with this expression
if(rank(Sum([MedAid Amount]+Shortfall)/Sum(TOTAL([MedAid Amount]+Shortfall))) <= 5,
Sum([MedAid Amount]+Shortfall)/Sum(TOTAL([MedAid Amount]+Shortfall))
)
maybe with this expression
if(rank(Sum([MedAid Amount]+Shortfall)/Sum(TOTAL([MedAid Amount]+Shortfall))) <= 5,
Sum([MedAid Amount]+Shortfall)/Sum(TOTAL([MedAid Amount]+Shortfall))
)
Many thanks Maxgro, will use this and advise you accordingly
Regards.
Hi Maxgro
Kindly post the sample application as i am having trouble in reproducing your recommendations.
Regards.
PFA
Thank you Maxgro most appreciate