Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have these field/groups: Branch, OpeningDate, ClosingDate, Year, Month, Week
I'm using pivot table with Branch, Year, Month, Week as dimension and Sales as expression. User can select Year, Month, Week and Branch from menu. But, here I want to show only those Branch for which the following condition must satisfy:
* Only those Branch would be visible for which the Branch is open for at least a year, using OpeningDate value of a Branch and Year, Month, Week values from menu. If a specific Branch has OpeningDate and it doesn't complete a year, ie. the branch is opened just 2 months ago, then the Branch should never be shown. Also, if a specific Branch is opened and closed in the period for which user has selected Year, Month, Week, then Branch value shouldn't be displayed too.
Anyone?
Thanks in advance.
Could you post a sample app? I guess, you can achieve it using calculated dimension or Set Analysis.
you can done it by using calculated dimensions, but need to know
1)do you have any status field, like closed or open
2)and if branch in not closed, what will be date in Closing date field, it has null or any default date.
or share sample
Sorry, I couldn't display sample here. But I need some formula in dimension.
IsrarKhan: Yes, OpeningDate has value, like, '2008-01-01 00:00:00.000' and if shop is closed then it has ClosingDate value as '2008-01-01 00:00:00.000', else its NULL.