6 Replies Latest reply on Mar 1, 2017 5:39 AM by sreekanth D

Combine two measures data into one measure

sreekanth D Mar 1, 2017 3:14 AM

Hi All,

Can any find solution for this.

I am unable to combine two measures out put into single measure. For example Please check below screen and attached workbook.

Here i need to combine lesson 9 attendees form Semester-1 and lesson 1 attendess from Semester-2.

EX: Sem-1 lesson 9 attendees 82

Sem-2 lesson 1 attendees 86

we need : Sem-2 lesson 1 attendees===>86+82=168.

Tracy Rodgers Barry Plum Amy SchneiderThe specified item was not found.Barry PlumThe specified item was not found.Elissa Fink Christian Chabot@

Attendees.twbx 33.8 KB

1. Re: Combine two measures data into one measure

Tushar More Mar 1, 2017 3:25 AM (in response to sreekanth D)

Hi Sreekanth,

Please see the attached image.

Is this what you're looking for?

Best,
Tushar
Like Show 0 Likes(0)

Actions
2. Re: Combine two measures data into one measure

sreekanth D Mar 1, 2017 3:37 AM (in response to Tushar More)

No Thushar,

In that report you combined lesson 1 and Lesson 2 attendees
But what I need
combination of leeson 9 attenddes(82) from Semister-1 + Lesson 1 Attendees(86) from semester-2 = 162
We need this 82+86=162 in semester-2 Lesson 1

Please check above screenshots for more details.
Like Show 0 Likes(0)

Actions
3. Re: Combine two measures data into one measure

Mahfooj Khan Mar 1, 2017 4:10 AM (in response to sreekanth D)

Hi Sreekanth,

Is that what you wanted?
Just create a calculated field like this:

IF [Date]='Sem1' THEN [Lesson1]
ELSE
{FIXED [Course]: SUM(IIF([Date]='Sem1',[Lesson9],0))}+
{FIXED [Course]: SUM(IIF([Date]='Sem2',[Lesson1],0))}
END
Mahfooj
Like Show 0 Likes(0)

Actions
4. Re: Combine two measures data into one measure

Nikunj Bhardava Mar 1, 2017 5:27 AM (in response to sreekanth D)
Hi Sreekanth,

Please check attached workbook for your reference.
Hope this helps!

Thanks,
Nikunj

Book2.twbx 11.4 KB
Like Show 0 Likes(0)

Actions
5. Re: Combine two measures data into one measure

sreekanth D Mar 1, 2017 5:39 AM (in response to Mahfooj Khan)

Thanks Mahfooj. Yes this works perfectly.
Like Show 0 Likes(0)

Actions
6. Re: Combine two measures data into one measure

sreekanth D Mar 1, 2017 5:39 AM (in response to Nikunj Bhardava)

Thanks Bhardva
Like Show 0 Likes(0)

Actions