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]

any one?

[prma7799]

Can you please share expected output

[Anil_Babu_Samineni]

You have to explain the result whether how you will get.

[saumyashah90]

if i get this in any format is good with me(Text Box, chart,table,etc).

Expected Output:

Selection: RM1, 30/05/2017

Start of Month(End of previous month count) : 5

Closed :1

Downgrade:1

Downgrade Regroup:1

End of Month : 2

[prma7799]

As Anil said I want to know How we will get desire output.

[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.

[#8]

From what I understand your selection of RM1 will result in showing 0 values for closed,downgrade and so on.

In order to avoid this, you can use {1} In your set condition to ignore selections

=Count({<[Date]={$(=Max({1} [Date]))}, [Dataset Name])

in this manner

I hope it helps

[saumyashah90]

{1} would be helpful if RM1 is tagged to it in current month.

[#10]

could we map ID column and RM together?

Eg: replace the null values in the column loaded with the value obtained after comparing it with ID?