Enter data ' Feature - How to enter measures like cost and rate , as they don't show Σ after load.

[SureshR]

Team.,

could you please tell me how do i enter measure values in "Enter Data"  table say suppose i have three 

columns to enter data , Employee, cost and rate .I did enter data but when i enter cost and rate these are not shown up as measures and i cannot calculate or create any calculated measure on cost and rate columns , no sigma symbol Σ is showing up for the cost and rate after a load.can you please explain why?

Also if you could explain any feature that the values entered in "Enter data" such as cost and rate are not visible after refresh, we want data to be confidential and only enter once for calculations and should not be seen after refreshing report the values should disappear.

Thanks

Suresh Ramadurgam

[v-ljerr-msft · Accepted solution]

Hi @SureshR,

---

columns to enter data , Employee, cost and rate .I did enter data but when i enter cost and rate these are not shown up as measures and i cannot calculate or create any calculated measure on cost and rate columns , no sigma symbol Σ is showing up for the cost and rate after a load.can you please explain why? 

The sigma symbol Σ shows up when a column is Number type and the default summarization is not Don't summarize. So make sure your cost and rate column is just numbers(without any other symbols like $, % etc) when they're imported using Enter Data. You can format these number column as you want with the Format options after they're imported.

---

Also if you could explain any feature that the values entered in "Enter data" such as cost and rate are not visible after refresh, we want data to be confidential and only enter once for calculations and should not be seen after refreshing report the values should disappear. 

An option is to disable the load of the tables in the query editor as described here. In addition, here is a similar thread for your reference. 

Regards