How to add column in pivot table when there is no data in datamodel?

[#1]

Hi,

Is there any way we can add a row in pivot table as I have all data for the first four rows. Only I need the row 'Working'.

name as :Working 

Header 1	Header 2	Header 3	Header 4	Header 5
week	1	2	3	4
Classroom	45	7	0	0
Auditroom	10	0	0	0
Total	55	7	0	0
Working	5	5	5	5

what I need is I have to show the Working column with values always as 5. There is no data for these working in datamodel.I have the remaining data. only I need to add working. would it be possible. can anyone suggest me.

Thanks.

[juleshartley]

The best way to do this is to create the dimension within your data model, which should be very simple.

There are other methods, like 'Valuelist' but these should only be used as a last resort imho.

[alexandros17]

Add a new expression with lavel "Working" and expression value 5

Let me know

[#4]

exactly. the other expression with label as working and data values for all four columns a 5

[#5]

would this possible?