I am facing is that i cant show the other shares in pie chart which does not contain the share of HPK in my pie.But that is visible in my table chart.The code i used for pie chart generation is:
Sum({$<Pensionseinrichtung = {'HPK'}>} [HPV Buchwert])
/
only(Sum(Total{$<Pensionseinrichtung = {'HPK'},Stichtag_HPV = {'31.12.2018'}>}[HPV Buchwert])).I plotted this vs Source Kasse. I also want to show the remaining percentage as others for eg (100-(1.94+5.09)=92%) in my pie chart