Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a straight table ...
Now i need to show the sum of revenue for all the months of 2017 and the first 2 rows of the Date field at the topshould show, 2 privios yers revenue that is for 2015 and 2016 and then all the months of 2017 as shown in the image
how can i achieve this please find the attachment and snapshot and the excel file
For current year ( 2017) show the Revenue monthly wise and for previous Years (2015 and 2016) we need show the revenue as monthly avaerge.
Under date field the firts 2 rows should show previous year(2015 and 2016 ) and then current years full month
Please someone suggest me
Tahnks in advance
Hi,
check the attached.
Hi Varun thanks for the reply ...
I am attaching a excel file how do we handle this here ???
U have got the result from inline table
For current year show the data monthly wise and for previous yesr we need show the revenue as monthly avaerge
Also share the expected output table format and numbers
Hi Varun
there is no sample output ...
What you showed above that is how it should look like
but with the excel sheet i have shared
Is this what are you looking for?
Hi Varun ..
Do i need to keep entering in the futre till 2018 19 ans so inLine table ?
Is ther no other way doing this at expression table ?
for previous years it shoul be like AVG(Revenue)
and for current year which will diplsay all the month should be Sum(Revenue ) ..
I dont know how to get this
try
If([New Date] = '2015' OR [New Date] = '2016', Avg(Revenue), sum(Revenue))
OR simply
Avg(Revenue)
should work