Sales Tree- Tableau

1) Sales Tree has been created using the following data set.

2) In this step we are going to show Total Sales Volume with

combination of all Dimensions as like below image.

3) Next 2 steps tells about how to model t he data.

3.1) Add new Field the "Sales Tree" with the values "S.T.". (Data Model sheet -1)

3.2) Create a new sheet as like below image. (Data Model sheet -2)

4) Now there are having 2 Sheets in our Data Model Set apart from Underline Data set(Actual data set).

5) Now Connect Tableau to the above Data set

.

6) Create 5 calculated fields as below.

Name: 1st

Syntax: RUNNING_SUM(1/(Size()+1))

------------------

Name: 2nd

Syntax: RUNNING_SUM(1/(Size()+1))

--------------------

 Name: 3rd

Syntax: RUNNING_SUM(1/(Size()+1))

--------------------

Name: Temp

Syntax: 1/(1+EXP(1)^-[Sizeofline])

-------------------

Name: Tree

Syntax: [1st]+([2nd] - [1st])*ATTR([Temp])

7) Now Drag the "Tree", "Sizeofline" Fields onto Column, Row shelf Respectively.

8) Right click on "Sizeofline" field on the rows shelf then convert into Dimension.

9) Drag the "Dimension" onto Detail Shelf.

then Right click on "Tree" then Define the Calculation as below.

10) Now report get changes as below.

11) Now prepare 2 Separate Reports, where 1 is for Summary (Dimension Name) 2nd is for detail (Dimension Values ).

13) Now Add the Dimension Name, Dimension Values, Tree Reports to the Dashboard.

14) And apply the Filter to all Reports.