Show distinct values for unique keys

[#1]

Hi guys,

Hopefully you can help me out with the following issue:

Consider the following data in xls:

Category	KPI	Measure	Value
Finance	GM	%	1
HR	GM	%	2
Customer service	GM	#	3
Customer service	GM	%	4

I made this key: %KEY_Category_KPI_Measure in QV.

I built a straight table with KPI as dimension and Measure and Value as expressions.

Then, when I filter by selecting 'Customer Service' as Category, I see just 1 KPI (GM), no measure and a value of 7 (3+4). Like this:

KPI	Measure	Value
GM		7

However, I would like to see 2 KPI's (GM and GM) with their measures (# and %) and values (3 and 4). Like this:

KPI	Measure	Value
GM	#	3
GM	%	4

What am I doing wrong?

Thanks for your help!

Hank

[MayilVahanan · Accepted solution]

HI

Try like this

Measure,KPI as dimension, and use

Value as expression

Can you share a sample file?

Hope it helps

[#3]

Hi HanKargel,

Can you please tell us that how many types of measures do you have ( i mean #, %).

we can go for a "ONLY" expression with set analysis which can give you individual values. but if you have more measures i think it won't works.

Thanks

Meher

[#4]

Thanks guys,

I should have used Measure as a dimension instead of an expression.