I am bemused by this area. Hope it wont be to confusing to understand.
1st question:There are three columns. One is titled Category(beverage, food etc...) the 2nd is titled Types of Data ( total value,the sum of beverage cost..etc,), 3rd column titled Spoilage, 4th column onwards show the value of these costs. When I tried to insert calculated field into it, in the dialog box, the field shows: Category, Spoilage.. I want to add field using the category,->category*2. But the answers are 0. Why is it so? There are values in the 4th column.
2nd question: Is the calculated field and calculated item are similar?
Thanks for answering!
2007-03-01 04:27:34 · 2 answers · asked by valerie 2 in Computers & Internet ➔ Programming & Design
Calculated field and calculated item are different. Calculated field is easier to figure out and calculated item is a beast to use.
2007-03-01 06:44:31 · answer #1 · answered by unnga 6 · 0⤊ 0⤋
the way will be to insert a column for share increas interior the unique table that created the pivot table then comprise this column interior the suggestion variety for the Pivot table.
2016-12-05 02:42:21 · answer #2 · answered by lesure 4 · 0⤊ 0⤋