Scenario
6:
Problem:
Showing Sum(sales) for pane with out repeating same value.
See
below:
In
above image I am showing sum(Sales)
for each customer segment by each
pane.
The
above scenario we can show in two different ways. But User want to
see like above only.
See
the other two ways below:
In
above image we are seeing sum(Sales)
values for each row. Same value is repeating for each row
in the pane.
But
user wants to see only one value per each pane. How
to do it?
Solution:
Its
very simple but since longtime I don’t know this.
Step
1: Create calculated field “window_sum”
using below formula.
if
last()=0 then window_sum(sum(Sales))
else
NULL
END
Step
2: Drag Customer Segment,
Region, Sales
and window_sum to row shelf.
Then go to show me and select first row first option. See
below
Then
it will create a text table like below
Step
3: Now right click on “window_sum”
column which is there in measure values shelf and go to
“Compute using” then select “Pane Down”. See
below
Step
4: Now you will see “Window_sum along
pane (Down)” column header in the report. Just right
click on that and select edit alias. Just give “sum(Sales)”
Finally
report look like below:
