Alternate State Not Showing All Data

[greend21]

I created a pivot a month or two ago that shows counts per month per system. Today I added data from an additional system but the data will not show in the pivot unless I take the alternate state(BillingSummary) out of the expression. I'm drawing a blank on why this would happen. Any ideas?

Num(Count({BillingSummary<InFRoll13Flag = {1}>*$}DISTINCT InFPolicyNumber), '#,##0')

[lorenzoconforti]

Maybe that alternate state is filtered and can't see it? what if you add Current selections box object pointing to that alternate state

Does it show any filter being applied?

[greend21]

I just tried that after you suggested it just in case but there isn't anything i'm not already away of. I'm using the alternate state for a few selections because I want one of the options always defaulted to selected, but I do not want it to affect data on other sheets. If I take the alternate state out of the set analysis then the selection does not filter this pivot as it should but then I can see the new system's data. The new system I added is unioned to the others so the data is in the same format. I'm really not sure what could be causing this issue.

[lorenzoconforti]

Two things might be happening here:

1. "I want one of the options always defaulted to selected": your default selection is somehow filtering out the new system data

2. "The new system I added is unioned to the others so the data is in the same format": the new system data might have similar format but reside in a different table (i.e. the data structure is inconsistent)

Options:

- share the data model so that we can help you quickly

- if you can't share the data model, share a screenshot of the database structure (CTRL+T)

- share more info about the tables and expressions

[greend21]

Oddly enough, I reloaded the data this morning and now my data shows with even with the alternate state in the set analysis.