Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to calculate the Yield Per Month i,e If I have selected 3 months it should show the average of 3 months(total sales of 3 months/3). If nothing has been selected it should show average of 12 months(total sales from jan-dec/12). Anyone knows how to do that.
Total column should be at last after December column or if I select 3 months then total column should come after the 3rd month.
This is how the report is without total column.
Hi,
I thought about two ways how to add this additional (Total / Average) column at the end of report.
1-method. You need to load one additional table. But in this way, you can add more than one column (for egxample Total, Average,......)
2-method. It is simplier way. You need to mark "Show Partial Sums" and use SecondaryDimensionality() in the expression. But in this way, you can add only one column.
Look at the application attached to get more detail explanation.
Hi Milda,
I got to know what mistake I was doing. I did not added MonthNum in script that's the reason it is not showing the average.
Many thanks milda! You have done a wonderful job.