Master item for a field in a table

[Kohli]

i have filed like:

Emp.ID,Basic Salary

1, 10000

1, 20000

1, 10000

1, 30000

2, 20000

2, 30000

4,30000

5,20000

5,30000

;

• Create master item for Total Base salary

[Lisa_P]

Go to Master Items, Measures, Create New, Create the expression sum([Basic Salary]) and give it the Name Total Base Salary

[DavidŠtorek]

Hi,

if you want to see sum for all emp.ID than use expression sum(total [Basic Salary]).

[kkkumar82]

If you think it should not take selections then create the expression as Sum({1} Sales)

[ramkrishna86]

What exactly do you required? I think this is pretty simple and you can use sum of all Basic Salary.

[ishanbhatt]

Go to Master Measure section. Create a new measure, write Expression Sum( [Basic Salary]).