ignore the dimension

[shilina_klara]

Help, people are kind. Sorry for my english (translator)

How can I make the numbers in the second column in all dimensions (measurements from another table, so, accordingly, he does not count on them). We can say that he ignored the second dimension.

The first measurement of the MonthYear, second - Experience

should work out like that. is this real?

[devarasu07]

Hi,

You can ignore the dimension like this using set analysis in your measure expression

=sum({$<MonthYear=>} Measure)

P.s: In your chart, to show the MonthYear repeat value try to use stright table instead of pivot table

Thanks,

Deva

[tresesco]

Using TOTAL in the expression should work. Try something like:

=Sum( Total <Experience> Sales)

Adjust to fit in your context.

[shilina_klara]

Hello!

thanks for the advice.

I tried this method, but it does not work, I do not have one expression inside the set analysis

[shilina_klara]

Hello!

and so I also tried it, it calculates incorrectly

[tresesco]

Could you share your sample qvw?

[shilina_klara]

Unfortunately, I can not share data, because there is confidial information.

There is a Payroll fund table, where there are many columns and one of them is Month / Year and Active number for people (each line is a person).

There is a table Dismissed, where too many columns, including Month \ Year and Experience for people (each line is a person).

And I can do it the way that I ask you to help, or how to pull up the date of dismissal to the Payroll fund table/

[tresesco]

You don't have to share your actual qvw. You can always create a sample qvw with mock data and share. With sample to work on, it becomes easier for us to help. Preparing examples for Upload - Reduction and Data Scrambling

[Anonymous]

How about

=Sum( {1 <Experience>} Sales)

[Kushal_Chawda]

what is your second column expression?