Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
Please can anyone help on this.
Iam attached a file for calculation of Linest function with Average function.
Thanks in advanced
You can create a Pivot Table and use the R# and Date as dimensions. The Date dimension you will have to drag so it displays horisontally instead of vertically. You will have two expressions:
The first with the label =' ' with this expression:
and you will have to set the "Display Options" / "Representation" to "Image" in the dropdown as shown below:
The second named # with this expression:
If( ColumnNo(), Sum(#) , Alt( Num( LINEST_M(Date,#) ,'0.0000000','.',',') ,0 ) )
You can create a Pivot Table and use the R# and Date as dimensions. The Date dimension you will have to drag so it displays horisontally instead of vertically. You will have two expressions:
The first with the label =' ' with this expression:
and you will have to set the "Display Options" / "Representation" to "Image" in the dropdown as shown below:
The second named # with this expression:
If( ColumnNo(), Sum(#) , Alt( Num( LINEST_M(Date,#) ,'0.0000000','.',',') ,0 ) )
Thank you Petter.
Its working.You are give good suggestion to me.