Want to show last Fiscal QTD in Textbox

[rupaliqlik]

Hi Folks,

I have a fiscal quarter  starts from Oct to Sep.

Q1-Oct to Dec

Q2-Jan to Mar

Q3-Apr to Jun

Q4-Jul to Sep.

As per user requirement in dashboard I have to show last fiscal QTD .For E.g,

Now It should show Q3-Apr to jun till Sep.In jun it should show Jan To Mar.

How to set these in Textbox with the hep of set analysis or variables.

Please guide me.

sunny t

Thanks,

Rupali Ethape

[Vegar]

Try to adjust this expression to your needs.

'Q' & if(Ceil(Month(YourDate)/3)=4,1,Ceil(Month(YourDate)/3)+1)&'-' & quartername(YourDate )

To calculate someone within this quarter adjust this expression.=dayname(quarterstart(MAX(YourDate), -1))) <$(=dayname(quarterstart(MAX(YourDate))))"}>}Quantity)

If you want the expressions to calculate todays last quarter you replace YourDate with Today()

If you want the expressions to calculate last quarter for the highest date in your selection you replace YourDate with $(=max(Date field))

[rupaliqlik]

It is not working.Can you give example with sol.

[Vegar]

I'm sorry, I'm not familiar with the term "sol".

[rupaliqlik]

• Q2 the [Sales] column will show sales for Q2 and [Previous QTR Sales] Shows Q1 sales
• Q3 the [Sales] column will show sales for Q2 and [Previous QTR Sales] Shows Q2 sales
• Q4 the [Sales] column will show sales for Q2 and [Previous QTR Sales] Shows Q3 sales