Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi can i check is there anyway we can add a sum function in Qlikview Presentation tab, dimension label of total.
Date | Total Sales : 313023.65 | |||
Customer Class | Sales Person | Customer | Invoice Sales | Cons. Sales |
GT | Prabu | Store A | 31,124.15 | 381.77 |
GT | Prabu | Store B | 265.17 | 0 |
GT | Prabu | Store C | 761.56 | 0 |
GT | Prabu | Store D | 1,886.85 | 0 |
GT | Prabu | Store E | 126,340.78 | 0 |
GT | Prabu | Store F | 152,263.37 | 0 |
Please note the total sales is including the total invoice sales + Cons. Sales
Total Sales is the dimention lable of total. (Inititally the lable is name as Total.
Simple option is create Text object and place on top of it. Still you want to do within object. Please share sample test application to do work around
Hi,
If you have the sales in one column and a dimension column with the values "Invoice "Sales" and "Cons. Sales" you will be able to do it with a pivot table.