BusinessObjects Board

Calculation of Prior Quarter based on current Quarter logic in IDT

building semantic layer
,
#1

Calculation of Prior Quarter based on current Quarter logic

#2

Welcome to B :bob: B, Arya!

You should provide more detail for your question is you would like to get answers. Perhaps provide an example of what you have tried that isn’t giving you the results that you want. The more information that you can provide in your post, the better the chance someone will be willing and able to assist you.

#3

Use a smart calendar table that refreshes daily to help create the objects.

Each date will have an int flag for 1/0 to indicate if it is current quarter, current month, previous month, previous year or integers with months ago, etc. depending on how you want to implement it

You can then build case expressions to support your objects, e.g.
Current Quarter Sales
=SUM(CASE WHEN CalendarTable.QuartersAgo=0 THEN FactSales.Qty ELSE 0 END)

Previous Quarter Sales
=SUM(CASE WHEN CalendarTable.QuartersAgo=1 THEN FactSales.Qty ELSE 0 END)

That should set you on the right track.