Set Analysis help

[saumyashah90]

Please find attached file with data.

I want to have different count of data

when i click on RM1

for date 30/05/2017

i should get count of Id's which are closed,downgrade,regrouped separately .

Out Put Expected:

Selection: RM1, 30/05/2017

Start of Month : 5

Closed :1

Downgrade:1

Downgrade Regroup:1

End of Month : 2

[saumyashah90]

You will have to check previous month RM to that ID and tagg the same to null in current month.

[saumyashah90]

'No change' type1 are the ID's which are active

'Downgrade' type1 are the ID's which are closed in this month.

So here when you see there some ID's which are active in April but 3 ID's get closed in May(Closed,Downgrade,Regroup). hence current month end only 2 ID's are active. This Count will become start of my next month(June).

Issue is there is no RM1 tagged in Current month for those ID's which are Downgrade(Type1).

So on selection of RM1 and Current month date i need count of ID's which are closed,downgrade and regroup.

[trdandamudi]

Please see the attached file and hope this helps....

[saumyashah90]

Hi Thirumala,

Thanks for your response but

1) Data selected was a text

2) If there are more RM's it wont work. I have changed the date format and added one more RM2 so that it looks clear.

Request you to please help on the attached.

[trdandamudi]

I tried but no able to achieve what you need.. But hope some one will help you out...

[saumyashah90]

Any one?

[MK9885]

I don't understand your requirement.

What are you looking for?

Count of records for end of previous month?

Provide a screenshot for expected output.

Maybe use Master Calendar and pivot/straight table for adding set expressions

Or stalwar1‌ can help you out in Set expressions.

[sunny_talwar]

What is the expected output based on this new data?