date dimention in table

[adiarnon]

hi,

i have this table in my scheme-

date	name
1.1.14	A
2.1.14	B
3.1.14	A
4.1.14	A
5.1.14	B
6.1.14	A
7.1.14	B

and this table in my model (PIVOT)-

name	1.1.14	2.1.14	3.1.14	4.1.14	5.1.14	6.1.14	7.1.14
A	1		1	1		1
B		1			1		1

if im filtering only on name 'A'  its giving me only the date (1.1.14,  3.1.14,  4.1.14,  6.1.14) and 1 in all the columns

i whant that it will show me all tha dates not just the date that A active...

i tried show all values

and i unchacked the supress null...

help please,

[jonathandienst]

Hi

You can do this with a disconnected (island) table. Because the island date field is not connected to the main table, selecting a name does not reduce the possible date values. See the attached example.

HTH

Jonathan

[#3]

Hello,

Why do not you use Pivot table with date and name as dimension and 1 as expression. And then drag the date field to vertical.

Thanks.

Angad