I get stuck whenever I try to add the Previous year's sales in the row shelf it shows 4 nulls values but the current year sales show me results as expected
@@helpful_tipss I need to calculate Qtr over Qtr in TableView using CalculatedFields. I don't want to use QuickTable, WindowFunction, or Lookup. Only want to make key using CalculatedFields. So the requirement is, I need Qtr over Qtr in TableForm for all the rows. Calculation should be at row level. I don't want to use parameters because it will only give me for a particular Qtr. But I want the calculation should be there for all the Qtrs. Is there any possible way because I am able to create it using parameters. But I want it to be done for all the Qtrs, not only for a specific one. And also want to mention that I don't have data till current date. So when I put today, I don't get values. And when I use maxDate, then I only get data for most prior and most recent Qtr. I don’t want to use tabulae prep or any etl or self join So please help me with some calculations.
I need to calculate Qtr over Qtr in TableView using CalculatedFields. I don't want to use QuickTable, WindowFunction, or Lookup. Only want to make key using CalculatedFields. So the requirement is, I need Qtr over Qtr in TableForm for all the rows. Calculation should be at row level. I don't want to use parameters because it will only give me for a particular Qtr. But I want the calculation should be there for all the Qtrs. Is there any possible way because I am able to create it using parameters. But I want it to be done for all the Qtrs, not only for a specific one. And also want to mention that I don't have data till current date. So when I put today, I don't get values. And when I use maxDate, then I only get data for most prior and most recent Qtr. I don’t want to use tabulae prep or any etl or self join So please help me with some calculations.
Grt bro - the way u handle the session - keep going on ........................🤝🙏
Thank you Venkat 👍🏻
Thank you so much for the video , keep up the good work !
i learnt some new tips
Thank you Fawzan. I am glad you liked the video 👍🏻
Thanks and a question, how can I sort final chart by difference?
I get stuck whenever I try to add the Previous year's sales in the row shelf it shows 4 nulls values but the current year sales show me results as expected
Can you check the calculated fields again? What all years of data you have in the dataset that you are using?
What if I don’t when to use parameter,as at the same time I want to previous quarter calculated for all quarters.
Can you give more details on the requirement? Here, we are comparing sales of the year selected by the user with the previous year sales.
@@helpful_tipss I need to calculate Qtr over Qtr in TableView using CalculatedFields. I don't want to use QuickTable, WindowFunction, or Lookup. Only want to make key using CalculatedFields. So the requirement is, I need Qtr over Qtr in TableForm for all the rows. Calculation should be at row level. I don't want to use parameters because it will only give me for a particular Qtr. But I want the calculation should be there for all the Qtrs. Is there any possible way because I am able to create it using parameters. But I want it to be done for all the Qtrs, not only for a specific one. And also want to mention that I don't have data till current date. So when I put today, I don't get values. And when I use maxDate, then I only get data for most prior and most recent Qtr. I don’t want to use tabulae prep or any etl or self join
So please help me with some calculations.
I need to calculate Qtr over Qtr in TableView using CalculatedFields. I don't want to use QuickTable, WindowFunction, or Lookup. Only want to make key using CalculatedFields. So the requirement is, I need Qtr over Qtr in TableForm for all the rows. Calculation should be at row level. I don't want to use parameters because it will only give me for a particular Qtr. But I want the calculation should be there for all the Qtrs. Is there any possible way because I am able to create it using parameters. But I want it to be done for all the Qtrs, not only for a specific one. And also want to mention that I don't have data till current date. So when I put today, I don't get values. And when I use maxDate, then I only get data for most prior and most recent Qtr. I don’t want to use tabulae prep or any etl or self join
So please help me with some calculations.
This is really good, how would i view this on a monthly level?