Saturday, 15 March 2014

table - How to get Excel Pivot 'Summarize by' to return actual data values not sum, avg, etc? -


I am using Excel Powerpivot with data in ITEM level data with a brand attribute in Table 1 in two different tables The table 2 has brand level data. Two tables are added to the brand key. The measurements I am using are non-pairs i.e. IMS is not equal to the brand. Set with measurement Is obtained.

Excel assumes that I want to summarize the IRMM in a brand level by implementing SUM, MAX, MIN, AVG etc. Do I want to return the actual value from the actual ITEM or the Brad-level table and do not apply any calculations for the values, is it possible?

If you are trying to effectively, then a different result is generated for the brand rows (For example, blank), then the answer is to write another solution that examines a logic that the row in question is ITEM or a brand or not.

  = IF (HASONEVALUE (table 1 [item]), [mazer], blank ())   

Keep in mind that it is for your current axis Will work, but may not be suitable for all the pavots.

It assumes that you have clearly made a measure called [remedy] and you are not just dragging numerical columns into the value box. If you can create something like this in the initial [remedy]:

  = sum (table 1 [value])   

Where is the value you want column Although to use in a measurement, if you have used a yoga, if it is related to an item, in which there is a row in the table, then it will give the desired result.

No comments:

Post a Comment