Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I wanted to make a bar chart out of the same table chart but some reason the bar chart is not displaying the same data.
The percentage value is not right in the bar chart.
The percentage value for the table chart is just Percentage=([HPV Buchwert])/([HPV Buchwert D]) where HPV Buchwert D is a conditional loop statement
which is shown in the below picture in highlighted text
The percentage value for the bar chart Percentage share=Sum( [HPV Buchwert])/Only(Sum(Total{$<Pensionseinrichtung, Stichtag_HPV = {'31.12.2018'}>}[HPV Buchwert]))*100.
For the bar chart the two dimensions I have used are Pensionseinrichtung and Source Kasse
I want that the percentage column in table chart for percentage shows the same in bar and table chart.
is possible to share app
or what is ur bar chart second dimension
Unfortunately i dont have access to share qvd.
Stack is Pension name
Bar is Souce Kasse
the difference is because of dimensions used in both chart and table