var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Pivot Table and Pivot Chart
I have a question to ask on the pivot table.
I am using the data in my reservation table. But however, I have encounter the problem is that the data show "Number" instead of the "Text"
Eg. The employee name and tool name . It reflect 1 and 2 in the table.
However, my reservation table show the text of the employee name and tool name..
Are you sure that the fields data in your reservation table really has text type?
You can see the result of numbers (in PivotTable/Chart View) when field source is any ID. In datasheet view you can see text, but in Design View that field has number type. Check up your field type in Design View.
The field I look up for the Employee ID.. That why I got the number.. Okay but how can I possible change into text coz that Employee ID is under one to many relationship.
You can create Query based on your main table and your table with stored names. In query you select Employee Name instead Employee ID. So you can start query in Pivot Chart /table View.