Question:
A * appears instead of key figure in results area.
A value is in the cell (in Excel formula bar), the appearance of the cell is as a *.
Ex.: $100 appears as * in the cell.
Why?
Answer:
This typically happens if your units of measures are mixed for that column. meaning you have $ and some other currency trying to display in the same column.
You can either pull the unit of measure into your query and restrict it to only $ or you can use a formula and use the NODIM function to ignore the unit of measure.
Answer:
You can also use the currency translation to have all currencies in $...