Replace the Sum(…) prefix in PowerPivot

20/11/2011

תגובה אחת

Problem:

when playing with PowerPivot and adding  ∑Values you get the prefix Sum(…) before the value.

image

Solution:

1.Click on the dropdown combo on the right hand.

image

2. Click on Edit Measure.

3.Copy the Formula in the “Measure will use this formula” …

image

4.Click on the New Measure icon in the Power Pivot Ribbon

image

5.paste the formula to the measure settings and change the measure name.

image

6. That’s it. now you have a new calculated member with your own caption ( Alias or what ever)

image

Enjoy it!!!

הוסף תגובה
facebook linkedin twitter email

כתיבת תגובה

האימייל לא יוצג באתר. שדות החובה מסומנים *

תגובה אחת

  1. Evangelinedhq23/12/2013 ב 11:34

    Replace the Sum(…) prefix in PowerPivot | Business Intelligence,Technology, Thoughts, Thinking wwtyggtc ghd lisseur midnight collection

    הגב