I am using a data label to summarize some data I have on the page. This is an average or 12 months of data (shown in the grand total below) is what I am after.
However since my data label uses month in the slicer, my answer comes out to 44.89.
Is there any way around this?
I was able to figure out a solution by breaking down the components of the formula to individual items and rewriting the formula.
Could you please post an how-to?
@romero.olivier It is similar to a table I found. The issue I had at the time is I literally copied a table and it had the same rows and columns. At the time I had date as a row. If you simply had A/B as a formula it returned A/B for the first month even though it didn’t show the months as rows.
Output of A/B Similar to first row in table above
If you used SUM(A)/SUM(B) it would return the number I was looking for.
Output of SUM(A)/SUM(B) similar to 23534856/372331670
Hope this helps