Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table like this:
Year | Key | Field | Type | Value |
---|---|---|---|---|
2008 | 001 | Object | A | 2 |
2008 | 001 | Object | B | 3 |
2008 | 001 | Player | A | 18 |
2008 | 001 | Player | B | 3 |
2008 | 001 | Book | A | 7 |
2008 | 001 | Book | B | 12 |
... | ... | ... | ... | ... |
and I want to creare a "Horizontal Stacked Bar Chart" with dimension:
Stack = Key
Bar = Field
and measures:
(Sum(Value)/sum(total(Value)))
Measures need to show the percent.
It show in this way:
but I need to show something like this:
I think that I need to modify the Measure expression to calculate the percent in a way that is right to take the full value, but I don't know how.
Thanks to all
could you attach a sample app woth mock data?
try this Sum(Value)/sum(total<Key> Value)
personal e.g. below
Sum(LineSalesAmount)/Sum(total<Year> LineSalesAmount)
Year is the stack